DBA Data[Home] [Help]

APPS.PAY_IE_P35 dependencies on PAY_RUN_RESULTS

Line 252: pay_run_results prr,

248: per_assignments_f asg,
249: pay_assignment_actions paa,
250: pay_payroll_actions ppa,
251: per_time_periods ptp,
252: pay_run_results prr,
253: pay_element_types_f pet,
254: pay_input_values_f piv1,
255: pay_run_result_values rrv1
256: WHERE per.person_id = p_person_id

Line 976: pay_run_results prr,

972: -- Dont create action if the latest tax basis is exclusion 5867343
973: CURSOR csr_exclusion (p_action_id NUMBER) IS
974: SELECT 'Y', ppa.action_type
975: FROM pay_run_result_values prrv,
976: pay_run_results prr,
977: pay_input_values_f pivf,
978: pay_element_types_f pet,
979: pay_assignment_actions paa,
980: pay_payroll_actions ppa

Line 998: pay_run_results prr,

994: -- Dont create action if the tax basis is exclusion for whole year(Tax Period).
995: CURSOR csr_exclusion_year (p_action_id_min NUMBER, p_action_id_max NUMBER, p_asg_id NUMBER) IS
996: SELECT count(1) cnt
997: FROM pay_run_result_values prrv,
998: pay_run_results prr,
999: pay_input_values_f pivf,
1000: pay_element_types_f pet,
1001: pay_assignment_actions paa,
1002: pay_payroll_actions ppa

Line 2631: pay_run_results prr,

2627:
2628: CURSOR csr_exclusion_flag (p_action_id_min NUMBER, p_action_id_max NUMBER, p_asg_id NUMBER) IS
2629: SELECT count(1) cnt
2630: FROM pay_run_result_values prrv,
2631: pay_run_results prr,
2632: pay_input_values_f pivf,
2633: pay_element_types_f pet,
2634: pay_assignment_actions paa,
2635: pay_payroll_actions ppa

Line 7789: pay_run_results prr,

7785: per_assignments_f asg,
7786: pay_assignment_actions paa,
7787: pay_payroll_actions ppa,
7788: per_time_periods ptp,
7789: pay_run_results prr,
7790: pay_element_types_f pet,
7791: pay_input_values_f piv1,
7792: pay_run_result_values rrv1,
7793: per_assignment_extra_info paei --6633719

Line 7911: pay_run_results prr,

7907: per_assignments_f asg,
7908: pay_assignment_actions paa,
7909: pay_payroll_actions ppa,
7910: per_time_periods ptp,
7911: pay_run_results prr,
7912: pay_element_types_f pet,
7913: pay_input_values_f piv1,
7914: pay_run_result_values rrv1
7915: WHERE per.person_id = p_person_id

Line 8021: pay_run_results prr,

8017: per_assignments_f asg,
8018: pay_assignment_actions paa,
8019: pay_payroll_actions ppa,
8020: per_time_periods ptp,
8021: pay_run_results prr,
8022: pay_element_types_f pet,
8023: pay_input_values_f piv1,
8024: pay_run_result_values rrv1,
8025: per_assignment_extra_info paei