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.HR_TERMINATION_SS dependencies on PER_PERIODS_OF_SERVICE

Line 28: FROM per_periods_of_service pps

24:
25:
26: CURSOR csr_new_object_number(p_period_of_service_id in number) is
27: SELECT object_version_number
28: FROM per_periods_of_service pps
29: where period_of_service_id = p_period_of_service_id;
30:
31: ln_old_object_number number;
32: ln_period_of_service_id number;

Line 97: , per_periods_of_service pds

93: , per.employee_number
94: , per.object_version_number
95: from per_all_people_f per
96: , per_business_groups bus
97: , per_periods_of_service pds
98: , per_person_types pet
99: where pds.period_of_service_id = p_period_of_service_id
100: and bus.business_group_id = pds.business_group_id
101: and per.person_id = pds.person_id

Line 237: ,per_periods_of_service ppos

233: CURSOR csr_get_subordinate IS
234: SELECT ppf.person_id
235: FROM per_all_people_f ppf -- Bug 2130066 fix
236: ,per_all_assignments_f paf
237: ,per_periods_of_service ppos
238: WHERE paf.supervisor_id = l_number_value
239: AND paf.person_id = ppf.person_id
240: AND ppf.person_id = ppos.person_id
241: AND ppf.current_employee_flag = 'Y'

Line 572: from per_periods_of_service

568: l_pds_information_category := p_pds_information_category;
569:
570: select business_group_id
571: into l_business_group_id
572: from per_periods_of_service
573: where period_of_service_id = p_period_of_service_id;
574:
575: hr_utility.trace('checking FR legislation ' || l_proc);
576: --

Line 1835: per_periods_of_service.actual_termination_date%TYPE;

1831: )
1832: IS
1833: lrt_termination hr_termination_ss.rt_termination;
1834: ld_actual_term_date
1835: per_periods_of_service.actual_termination_date%TYPE;
1836: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1837: ll_term_comments per_periods_of_service.comments%TYPE;
1838: ln_person_id per_all_people_f.person_id%TYPE;
1839: ln_period_of_service_id

Line 1836: lv_term_reason per_periods_of_service.leaving_reason%TYPE;

1832: IS
1833: lrt_termination hr_termination_ss.rt_termination;
1834: ld_actual_term_date
1835: per_periods_of_service.actual_termination_date%TYPE;
1836: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1837: ll_term_comments per_periods_of_service.comments%TYPE;
1838: ln_person_id per_all_people_f.person_id%TYPE;
1839: ln_period_of_service_id
1840: per_periods_of_service.period_of_service_id%TYPE;

Line 1837: ll_term_comments per_periods_of_service.comments%TYPE;

1833: lrt_termination hr_termination_ss.rt_termination;
1834: ld_actual_term_date
1835: per_periods_of_service.actual_termination_date%TYPE;
1836: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1837: ll_term_comments per_periods_of_service.comments%TYPE;
1838: ln_person_id per_all_people_f.person_id%TYPE;
1839: ln_period_of_service_id
1840: per_periods_of_service.period_of_service_id%TYPE;
1841: ln_object_version_number

Line 1840: per_periods_of_service.period_of_service_id%TYPE;

1836: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1837: ll_term_comments per_periods_of_service.comments%TYPE;
1838: ln_person_id per_all_people_f.person_id%TYPE;
1839: ln_period_of_service_id
1840: per_periods_of_service.period_of_service_id%TYPE;
1841: ln_object_version_number
1842: per_periods_of_service.object_version_number%TYPE;
1843: ------------------------------------------------------------------------
1844: -- out parameters required by API actual_termination_emp

Line 1842: per_periods_of_service.object_version_number%TYPE;

1838: ln_person_id per_all_people_f.person_id%TYPE;
1839: ln_period_of_service_id
1840: per_periods_of_service.period_of_service_id%TYPE;
1841: ln_object_version_number
1842: per_periods_of_service.object_version_number%TYPE;
1843: ------------------------------------------------------------------------
1844: -- out parameters required by API actual_termination_emp
1845: ------------------------------------------------------------------------
1846: ld_last_standard_process_date

Line 1847: per_periods_of_service.last_standard_process_date%TYPE;

1843: ------------------------------------------------------------------------
1844: -- out parameters required by API actual_termination_emp
1845: ------------------------------------------------------------------------
1846: ld_last_standard_process_date
1847: per_periods_of_service.last_standard_process_date%TYPE;
1848: ld_notified_term_date
1849: per_periods_of_service.notified_termination_date%TYPE;
1850:
1851: ld_projected_termination_date

Line 1849: per_periods_of_service.notified_termination_date%TYPE;

1845: ------------------------------------------------------------------------
1846: ld_last_standard_process_date
1847: per_periods_of_service.last_standard_process_date%TYPE;
1848: ld_notified_term_date
1849: per_periods_of_service.notified_termination_date%TYPE;
1850:
1851: ld_projected_termination_date
1852: per_periods_of_service.projected_termination_date%TYPE;
1853: ld_final_process_date

Line 1852: per_periods_of_service.projected_termination_date%TYPE;

1848: ld_notified_term_date
1849: per_periods_of_service.notified_termination_date%TYPE;
1850:
1851: ld_projected_termination_date
1852: per_periods_of_service.projected_termination_date%TYPE;
1853: ld_final_process_date
1854: per_periods_of_service.final_process_date%TYPE;
1855:
1856: lb_supervisor_warning BOOLEAN;

Line 1854: per_periods_of_service.final_process_date%TYPE;

1850:
1851: ld_projected_termination_date
1852: per_periods_of_service.projected_termination_date%TYPE;
1853: ld_final_process_date
1854: per_periods_of_service.final_process_date%TYPE;
1855:
1856: lb_supervisor_warning BOOLEAN;
1857: lb_event_warning BOOLEAN;
1858: lb_interview_warning BOOLEAN;

Line 2012: from per_periods_of_service

2008: --------------------------------------------------------------
2009: begin
2010: select business_group_id
2011: into l_business_group_id
2012: from per_periods_of_service
2013: where period_of_service_id = ln_period_of_service_id;
2014: --
2015: l_legislation_code :=
2016: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);