Can anyone help me in finding which tables stores the list of approvers for a SSHR transaction.
I mean on the review page. It shows the list of approvers that required returned from the AME. i want to find which table stores this information.
Thanks in Advance
Edited by: suma on Jul 3, 2012 7:22 AM
Please.. do any one have answer to this, how to get approvers list into a custom table. As the SS Review page is displaying the list of approvers, where does the AME store this vales ?
Thanks in advance
Edited by: A_C2324 on Jul 3, 2012 11:27 PM
I have achived this using the following approach. It works.
The Approvers List is generated by 'ame_dynamic_approval_pkg.get_ame_apprs_and_ins_list ' package, AME records the values into 'ame_approver_record2_ss'.
1) Create a Custom Table
2) Create a custom package
3) Call the 'get_ame_apprs_and_ins_list' procedure, in the custom package.
4 Assign approver record to a vairable
4) Insert values into the custon table