eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_P35 dependencies on PER_PERIODS_OF_SERVICE

Line 261: , per_periods_of_service pos2

257: AND per.current_employee_flag = 'Y'
258: AND per.effective_start_date =
259: (SELECT MIN (per2.effective_start_date)
260: FROM per_people_f per2
261: , per_periods_of_service pos2
262: WHERE per2.person_id = per.person_id
263: AND per2.effective_start_date <= p_end_date
264: AND pos2.person_id = per2.person_id
265: AND pos2.date_start between per2.effective_start_date and per2.effective_end_date

Line 737: from per_periods_of_service pos,

733: CLOSE csr_p30_process;
734: --
735: hr_utility.set_location ('End Date 3',22);
736: sqlstr := 'select distinct asg.person_id
737: from per_periods_of_service pos,
738: per_assignments_f asg,
739: pay_payroll_actions ppa
740: where ppa.payroll_action_id = :payroll_action_id
741: and pos.person_id = asg.person_id

Line 1481: l_pds_id per_periods_of_service.period_of_service_id%TYPE;

1477: l_period_type pay_all_payrolls_f.period_type%TYPE; --Bug 4154171
1478: -- Temporary variable to hold values when Class K or M exists
1479: l_temp_prsi_cont pay_action_information.action_information4%TYPE := NULL;
1480: l_oth_arch_ovn pay_action_information.object_version_number%TYPE;
1481: l_pds_id per_periods_of_service.period_of_service_id%TYPE;
1482: l_asg_id per_assignments_f.assignment_id%TYPE;
1483: l_aact_id pay_assignment_actions.assignment_action_id%TYPE;
1484: l_max_act_for_bal pay_assignment_actions.assignment_action_id%TYPE;
1485: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;

Line 1769: per_periods_of_service pps,

1765: FROM pay_action_information pact_edi,
1766: pay_action_information pact_iedi,
1767: pay_action_information pact_ad,
1768: per_assignments_f paf,
1769: per_periods_of_service pps,
1770: -- pay_ie_paye_details_f payef,
1771: per_time_periods ptp,
1772: per_people_f ppf
1773: WHERE pact_iedi.action_information_category = 'IE EMPLOYEE DETAILS'

Line 2008: per_periods_of_service pps,

2004: --14659262
2005: FROM pay_action_interlocks pai,
2006: pay_assignment_actions paa,
2007: per_people_f ppf,
2008: per_periods_of_service pps,
2009: per_assignments_f paf,
2010: per_addresses pad,
2011: -- pay_ie_paye_details_f payef, --Bug 4154171
2012: pay_all_payrolls_f papf,

Line 2245: per_periods_of_service pps,

2241: ) -- Q1_Previous_Emp_USC
2242: --14659262
2243: FROM pay_assignment_actions paa,
2244: per_people_f ppf,
2245: per_periods_of_service pps,
2246: per_assignments_f paf,
2247: per_addresses pad,
2248: -- pay_ie_paye_details_f payef,
2249: pay_all_payrolls_f papf,

Line 2394: FROM per_periods_of_service pps

2390: /*** Cursors for Previous employment balances */
2391: CURSOR c_get_periods_of_service(v_person_id NUMBER,
2392: v_assignment_id NUMBER) IS
2393: /*SELECT period_of_service_id
2394: FROM per_periods_of_service pps
2395: WHERE person_id = v_person_id
2396: AND actual_termination_date is not NULL
2397: AND actual_termination_date between l_start_date
2398: and l_end_date

Line 2401: FROM per_periods_of_service pps

2397: AND actual_termination_date between l_start_date
2398: and l_end_date
2399: ORDER BY actual_termination_date desc; */
2400: SELECT max(pps.period_of_service_id)
2401: FROM per_periods_of_service pps
2402: ,per_assignments_f asg
2403: ,pay_all_payrolls_f pay
2404: ,hr_soft_coding_keyflex flex
2405: WHERE pps.person_id = v_person_id

Line 7806: , per_periods_of_service pos2

7802: AND per.effective_start_date =
7803: (SELECT MIN (per2.effective_start_date)
7804: FROM per_people_f per2
7805: -- Bug Fix 4004384
7806: , per_periods_of_service pos2
7807: WHERE per2.person_id = per.person_id
7808: AND per2.effective_start_date <= p_end_date
7809: AND pos2.person_id = per2.person_id
7810: AND pos2.date_start between per2.effective_start_date and per2.effective_end_date

Line 8034: , per_periods_of_service pos2

8030: AND per.current_employee_flag = 'Y'
8031: AND per.effective_start_date =
8032: (SELECT MIN (per2.effective_start_date)
8033: FROM per_people_f per2
8034: , per_periods_of_service pos2
8035: WHERE per2.person_id = per.person_id
8036: AND per2.effective_start_date <= p_end_date
8037: AND pos2.person_id = per2.person_id
8038: AND pos2.date_start between per2.effective_start_date and per2.effective_end_date