APPS.PAY_AU_RECON_SUMMARY dependencies on PER_PERIODS_OF_SERVICE

Line 238: PER_PERIODS_OF_SERVICE PPS ,

234: PAY_INPUT_VALUES_F PIV,
235: PAY_ELEMENT_ENTRIES_F PEE ,
236: PAY_ELEMENT_TYPES_F PET ,
237: PER_ALL_ASSIGNMENTS_F PAA ,
238: PER_PERIODS_OF_SERVICE PPS ,
239: PAY_RUN_RESULTS PRR ,
240: PAY_ASSIGNMENT_ACTIONS PAC ,
241: PAY_PAYROLL_ACTIONS PPA
242: WHERE pbad.attribute_name = 'AU_EOY_ALLOWANCE'

Line 1549: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;

1545: l_result NUMBER;
1546: l_etp_service_date date; /* Bug# 2984390 */
1547: l_le_etp_service_date date; /* Bug 4177679 */
1548: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1549: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1550: l_date_start per_periods_of_service.date_start%TYPE;
1551: l_death_benefit_type varchar2(100);
1552: l_lst_yr_start date;
1553: l_etp_new_bal_total NUMBER ; /* Bug 9226023 - Variable declared to store the sum of Taxable and Tax Free portions of ETP balances

Line 1550: l_date_start per_periods_of_service.date_start%TYPE;

1546: l_etp_service_date date; /* Bug# 2984390 */
1547: l_le_etp_service_date date; /* Bug 4177679 */
1548: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1549: l_actual_termination_date per_periods_of_service.actual_termination_date%TYPE;
1550: l_date_start per_periods_of_service.date_start%TYPE;
1551: l_death_benefit_type varchar2(100);
1552: l_lst_yr_start date;
1553: l_etp_new_bal_total NUMBER ; /* Bug 9226023 - Variable declared to store the sum of Taxable and Tax Free portions of ETP balances
1554: introduced as part of patch 8769345*/

Line 1568: per_periods_of_service pps

1564: ,date_start
1565: ,pps.pds_information2
1566: from per_all_people_f p,
1567: per_all_assignments_f a,
1568: per_periods_of_service pps
1569: where a.person_id = p.person_id
1570: and pps.person_id = p.person_id
1571: and pps.period_of_service_id=a.period_of_service_id /*Bug 5397790 */
1572: and ( pps.actual_termination_date between c_lst_year_start --bug 3686549

Line 2985: INDEX(pps per_periods_of_service_pk)

2981: is
2982: SELECT /*+ INDEX(pap per_people_f_pk)
2983: INDEX(rppa pay_payroll_actions_pk)
2984: INDEX(paa per_assignments_f_N12)
2985: INDEX(pps per_periods_of_service_pk)
2986: */ paa.assignment_id
2987: from per_people_f pap
2988: ,per_assignments_f paa
2989: ,pay_payroll_actions rppa

Line 2990: ,per_periods_of_service pps

2986: */ paa.assignment_id
2987: from per_people_f pap
2988: ,per_assignments_f paa
2989: ,pay_payroll_actions rppa
2990: ,per_periods_of_service pps
2991: where rppa.payroll_action_id = p_payroll_action_id
2992: and pap.person_id between p_start_person_id and p_end_person_id
2993: and pap.person_id = paa.person_id
2994: 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 3073: ,per_periods_of_service pps

3069: SELECT paa.assignment_id
3070: from per_people_f pap
3071: ,per_assignments_f paa
3072: ,pay_payroll_actions rppa
3073: ,per_periods_of_service pps
3074: ,pay_population_ranges ppr
3075: where rppa.payroll_action_id = p_payroll_action_id
3076: and rppa.payroll_action_id = ppr.payroll_action_id
3077: AND ppr.payroll_action_id = p_payroll_action_id

Line 3150: INDEX(pps per_periods_of_service_n3)

3146: SELECT /*+ INDEX(pap per_people_f_pk)
3147: INDEX(paa per_assignments_f_fk1)
3148: INDEX(paa per_assignments_f_N12)
3149: INDEX(rppa pay_payroll_actions_pk)
3150: INDEX(pps per_periods_of_service_n3)
3151: */ distinct paa.assignment_id
3152: from per_people_f pap
3153: ,per_assignments_f paa
3154: ,pay_payroll_actions rppa

Line 3155: ,per_periods_of_service pps

3151: */ distinct paa.assignment_id
3152: from per_people_f pap
3153: ,per_assignments_f paa
3154: ,pay_payroll_actions rppa
3155: ,per_periods_of_service pps
3156: where rppa.payroll_action_id = p_payroll_action_id
3157: and pap.person_id between p_start_person_id and p_end_person_id
3158: and pap.person_id = paa.person_id
3159: 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