DBA Data[Home] [Help]

APPS.PAY_MX_PAYREG_PKG dependencies on DUAL

Line 20: nkjaladi 07-Feb-2013 120.1 14830976 Enabled Dual Maintainance

16:
17: Name Date Version Bug Text
18: ----------- ------------ ------ --------- ------------------------------
19: nkjaladi 06-Feb-2013 120.0 14830976 Created
20: nkjaladi 07-Feb-2013 120.1 14830976 Enabled Dual Maintainance
21: nkjaladi 20-Feb-2013 120.2 16364431 Modified Cursor GET_GRE and
22: Cursor GET_PR_ASG_ACT for
23: sorting the data.
24: *************************************************************************/

Line 71: FROM DUAL;

67: CURSOR GET_CURR_ACT_ID IS
68: SELECT 'TRANSFER_ACT_ID=P'
69: ,pay_magtape_generic.get_parameter_value(
70: 'TRANSFER_ACT_ID')
71: FROM DUAL;
72:
73: CURSOR GET_GRE IS
74: SELECT DISTINCT 'ROOT_GRE_TAG=P'
75: ,''

Line 93: FROM dual;

89: ,''
90: ,'PAYROLL_ACTION_ID=P'
91: ,pay_magtape_generic.get_parameter_value(
92: 'TRANSFER_PAYROLL_ACTION_ID')
93: FROM dual;
94:
95: CURSOR GET_PR_ASG_ACT IS
96: SELECT 'TRANSFER_ACT_ID=P'
97: ,assignment_action_id