APPS.PAY_IE_P35 dependencies on PER_PERIODS_OF_SERVICE

Line 254: , per_periods_of_service pos2

250: AND per.current_employee_flag = 'Y'
251: AND per.effective_start_date =
252: (SELECT MIN (per2.effective_start_date)
253: FROM per_people_f per2
254: , per_periods_of_service pos2
255: WHERE per2.person_id = per.person_id
256: AND per2.effective_start_date <= p_end_date
257: AND pos2.person_id = per2.person_id
258: AND pos2.date_start between per2.effective_start_date and per2.effective_end_date

Line 730: from per_periods_of_service pos,

726: CLOSE csr_p30_process;
727: --
728: hr_utility.set_location ('End Date 3',22);
729: sqlstr := 'select distinct asg.person_id
730: from per_periods_of_service pos,
731: per_assignments_f asg,
732: pay_payroll_actions ppa
733: where ppa.payroll_action_id = :payroll_action_id
734: and pos.person_id = asg.person_id

Line 1219: l_pds_id per_periods_of_service.period_of_service_id%TYPE;

1215: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171
1216: -- Temporary variable to hold values when Class K or M exists
1217: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1218: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1219: l_pds_id per_periods_of_service.period_of_service_id%TYPE;
1220: l_asg_id per_assignments_f.assignment_id%TYPE;
1221: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1222: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1223: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;

Line 1430: per_periods_of_service pps,

1426: FROM pay_action_information pact_edi,
1427: pay_action_information pact_iedi,
1428: pay_action_information pact_ad,
1429: per_assignments_f paf,
1430: per_periods_of_service pps,
1431: -- pay_ie_paye_details_f payef,
1432: per_time_periods ptp,
1433: per_people_f ppf
1434: WHERE pact_iedi.action_information_category = 'IE EMPLOYEE DETAILS'

Line 1635: per_periods_of_service pps,

1631: ) -- Q1_Previous_Emp_Tax
1632: FROM pay_action_interlocks pai,
1633: pay_assignment_actions paa,
1634: per_people_f ppf,
1635: per_periods_of_service pps,
1636: per_assignments_f paf,
1637: per_addresses pad,
1638: -- pay_ie_paye_details_f payef, --Bug 4154171
1639: pay_all_payrolls_f papf,

Line 1838: per_periods_of_service pps,

1834: 0
1835: ) -- Q1_Previous_Emp_Tax
1836: FROM pay_assignment_actions paa,
1837: per_people_f ppf,
1838: per_periods_of_service pps,
1839: per_assignments_f paf,
1840: per_addresses pad,
1841: -- pay_ie_paye_details_f payef,
1842: pay_all_payrolls_f papf,

Line 1979: FROM per_periods_of_service pps

1975: /*** Cursors for Previous employment balances */
1976: CURSOR c_get_periods_of_service(v_person_id NUMBER,
1977: v_assignment_id NUMBER) IS
1978: /*SELECT period_of_service_id
1979: FROM per_periods_of_service pps
1980: WHERE person_id = v_person_id
1981: AND actual_termination_date is not NULL
1982: AND actual_termination_date between l_start_date
1983: and l_end_date

Line 1986: FROM per_periods_of_service pps

1982: AND actual_termination_date between l_start_date
1983: and l_end_date
1984: ORDER BY actual_termination_date desc; */
1985: SELECT max(pps.period_of_service_id)
1986: FROM per_periods_of_service pps
1987: ,per_assignments_f asg
1988: ,pay_all_payrolls_f pay
1989: ,hr_soft_coding_keyflex flex
1990: WHERE pps.person_id = v_person_id

Line 4741: , per_periods_of_service pos2

4737: AND per.effective_start_date =
4738: (SELECT MIN (per2.effective_start_date)
4739: FROM per_people_f per2
4740: -- Bug Fix 4004384
4741: , per_periods_of_service pos2
4742: WHERE per2.person_id = per.person_id
4743: AND per2.effective_start_date <= p_end_date
4744: AND pos2.person_id = per2.person_id
4745: AND pos2.date_start between per2.effective_start_date and per2.effective_end_date