APPS.PAY_AU_RECON_SUMMARY dependencies on PER_PERIODS_OF_SERVICE

Line 187: -- ,per_periods_of_service pps

183: ,per_all_assignments_f paa
184: ,pay_balance_types pbt
185: ,pay_defined_balances pdb
186: ,pay_balance_dimensions pbd
187: -- ,per_periods_of_service pps
188: ,pay_payroll_actions ppa
189: ,pay_assignment_actions pac
190: ,pay_run_results prr
191: WHERE pac.assignment_id = c_assignment_id

Line 897: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

893: l_result NUMBER;
894: l_etp_service_date date; /* Bug# 2984390 */
895: l_le_etp_service_date date; /* Bug 4177679 */
896: l_current_employee_flag per_all_people_f.current_employee_flag%type;
897: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
898: l_date_start per_periods_of_service.date_start%TYPE;
899: l_death_benefit_type varchar2(100);
900: l_lst_yr_start date;
901:

Line 898: l_date_start per_periods_of_service.date_start%TYPE;

894: l_etp_service_date date; /* Bug# 2984390 */
895: l_le_etp_service_date date; /* Bug 4177679 */
896: l_current_employee_flag per_all_people_f.current_employee_flag%type;
897: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
898: l_date_start per_periods_of_service.date_start%TYPE;
899: l_death_benefit_type varchar2(100);
900: l_lst_yr_start date;
901:
902:

Line 914: per_periods_of_service pps

910: ,date_start
911: ,pps.pds_information2
912: from per_all_people_f p,
913: per_all_assignments_f a,
914: per_periods_of_service pps
915: where a.person_id = p.person_id
916: and pps.person_id = p.person_id
917: and pps.period_of_service_id=a.period_of_service_id /*Bug 5397790 */
918: and ( pps.actual_termination_date between c_lst_year_start --bug 3686549

Line 1769: INDEX(pps per_periods_of_service_pk)

1765: is
1766: SELECT /*+ INDEX(pap per_people_f_pk)
1767: INDEX(rppa pay_payroll_actions_pk)
1768: INDEX(paa per_assignments_f_N12)
1769: INDEX(pps per_periods_of_service_pk)
1770: */ paa.assignment_id
1771: from per_people_f pap
1772: ,per_assignments_f paa
1773: ,pay_payroll_actions rppa

Line 1774: ,per_periods_of_service pps

1770: */ paa.assignment_id
1771: from per_people_f pap
1772: ,per_assignments_f paa
1773: ,pay_payroll_actions rppa
1774: ,per_periods_of_service pps
1775: where rppa.payroll_action_id = p_payroll_action_id
1776: and pap.person_id between p_start_person_id and p_end_person_id
1777: and pap.person_id = paa.person_id
1778: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (p_fin_year_end)),1,'Y','N')) LIKE p_employee_type

Line 1847: INDEX(pps per_periods_of_service_PK)

1843: SELECT /*+ INDEX(pap per_people_f_pk)
1844: INDEX(rppa pay_payroll_actions_pk)
1845: INDEX(ppr PAY_POPULATION_RANGES_N4)
1846: INDEX(paa per_assignments_f_N12)
1847: INDEX(pps per_periods_of_service_PK)
1848: */ paa.assignment_id
1849: from per_people_f pap
1850: ,per_assignments_f paa
1851: ,pay_payroll_actions rppa

Line 1852: ,per_periods_of_service pps

1848: */ paa.assignment_id
1849: from per_people_f pap
1850: ,per_assignments_f paa
1851: ,pay_payroll_actions rppa
1852: ,per_periods_of_service pps
1853: ,pay_population_ranges ppr
1854: where rppa.payroll_action_id = p_payroll_action_id
1855: and rppa.payroll_action_id = ppr.payroll_action_id
1856: and ppr.chunk_number = p_chunk

Line 1918: INDEX(pps per_periods_of_service_n3)

1914: SELECT /*+ INDEX(pap per_people_f_pk)
1915: INDEX(paa per_assignments_f_fk1)
1916: INDEX(paa per_assignments_f_N12)
1917: INDEX(rppa pay_payroll_actions_pk)
1918: INDEX(pps per_periods_of_service_n3)
1919: */ distinct paa.assignment_id
1920: from per_people_f pap
1921: ,per_assignments_f paa
1922: ,pay_payroll_actions rppa

Line 1923: ,per_periods_of_service pps

1919: */ distinct paa.assignment_id
1920: from per_people_f pap
1921: ,per_assignments_f paa
1922: ,pay_payroll_actions rppa
1923: ,per_periods_of_service pps
1924: where rppa.payroll_action_id = p_payroll_action_id
1925: and pap.person_id between p_start_person_id and p_end_person_id
1926: and pap.person_id = paa.person_id
1927: and decode(pps.actual_termination_date,null,'Y',decode(sign(pps.actual_termination_date - (p_fin_year_end)),1,'Y','N')) LIKE p_employee_type