APPS.PAY_ES_TWR_CALC_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 571: FROM pay_payroll_actions

567: SELECT SUBSTR(legislative_parameters,
568: INSTR(legislative_parameters,p_token_name)+(LENGTH(p_token_name)+1),
569: INSTR(legislative_parameters,' ',
570: INSTR(legislative_parameters,p_token_name)))
571: FROM pay_payroll_actions
572: WHERE payroll_action_id = p_payroll_action_id;
573: --
574: l_token_value VARCHAR2(50);
575: --

Line 655: FROM pay_payroll_actions ppa

651: --
652: CURSOR csr_get_effective_date IS
653: SELECT ppa.effective_date
654: ,prt.shortname
655: FROM pay_payroll_actions ppa
656: ,pay_run_types_f prt
657: WHERE ppa.payroll_action_id = p_payroll_action_id
658: AND ppa.run_type_id = prt.run_type_id
659: AND ppa.effective_date BETWEEN prt.effective_start_date

Line 844: ,pay_payroll_actions ppa

840: SELECT 'N'
841: FROM dual
842: WHERE EXISTS(SELECT NULL
843: FROM pay_assignment_actions paa
844: ,pay_payroll_actions ppa
845: ,pay_run_results prr
846: ,pay_run_result_values prv
847: ,pay_element_types_f petf
848: ,pay_input_values_f pivf

Line 922: ,pay_payroll_actions ppa

918: CURSOR csr_get_assignment_action(c_assignment_id NUMBER
919: ,c_effective_date DATE) IS
920: SELECT paa.assignment_action_id
921: FROM pay_assignment_actions paa
922: ,pay_payroll_actions ppa
923: ,pay_run_results prr
924: ,pay_run_result_values prv
925: ,pay_element_types_f petf
926: ,pay_input_values_f pivf

Line 1091: FROM pay_payroll_actions ppa

1087: ,paa.assignment_action_id
1088: ,ppa.effective_date
1089: ,paa.action_status
1090: ,prtf.shortname
1091: FROM pay_payroll_actions ppa
1092: ,pay_assignment_actions paa
1093: ,per_all_assignments_f paaf
1094: ,pay_run_types_f prtf
1095: WHERE ppa.payroll_action_id = p_payroll_action_id