APPS.PAY_US_MMREF_REPORTING dependencies on PAY_ACTION_PARAMETERS

Line 388: FROM pay_action_parameters

384: WHERE paa.payroll_action_id = cp_payroll_action_id
385: AND paa.action_status = 'E'
386: )
387: AND NOT EXISTS ( SELECT '1'
388: FROM pay_action_parameters
389: WHERE parameter_name = 'FORCE_MAG_REPORT'
390: AND INSTR(parameter_value, 'E') > 0
391: );
392: --Cursor for checking if any of the assignments have been marked for retry

Line 402: FROM pay_action_parameters

398: FROM pay_assignment_actions paa
399: WHERE paa.payroll_action_id = cp_payroll_action_id
400: AND paa.action_status = 'M')
401: AND NOT EXISTS (SELECT '1'
402: FROM pay_action_parameters
403: WHERE parameter_name = 'FORCE_MAG_REPORT'
404: AND INSTR(parameter_value, 'R') > 0
405: );
406:

Line 912: from pay_action_parameters

908: IS
909: --Changes for bug 9467090
910: CURSOR csr_action_parameter is
911: select parameter_value
912: from pay_action_parameters
913: where parameter_name = 'RANGE_PERSON_ID';
914: --Changes for bug 9467090
915: p_year_start DATE;
916: p_year_end DATE;

Line 1891: from pay_action_parameters

1887:
1888: --Changes for bug 9467090
1889: CURSOR csr_action_parameter is
1890: select parameter_value
1891: from pay_action_parameters
1892: where parameter_name = 'RANGE_PERSON_ID';
1893: --Changes for bug 9467090
1894: --local variables
1895: l_year_start DATE;