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 230: ,per_periods_of_service ppos

226: CURSOR csr_get_subordinate IS
227: SELECT ppf.person_id
228: FROM per_all_people_f ppf -- Bug 2130066 fix
229: ,per_all_assignments_f paf
230: ,per_periods_of_service ppos
231: WHERE paf.supervisor_id = l_number_value
232: AND paf.person_id = ppf.person_id
233: AND ppf.person_id = ppos.person_id
234: AND ppf.current_employee_flag = 'Y'

Line 524: from per_periods_of_service

520: l_pds_information_category := p_pds_information_category;
521:
522: select business_group_id
523: into l_business_group_id
524: from per_periods_of_service
525: where period_of_service_id = p_period_of_service_id;
526:
527: hr_utility.trace('checking FR legislation ' || l_proc);
528: --

Line 1711: per_periods_of_service.actual_termination_date%TYPE;

1707: )
1708: IS
1709: lrt_termination hr_termination_ss.rt_termination;
1710: ld_actual_term_date
1711: per_periods_of_service.actual_termination_date%TYPE;
1712: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1713: ll_term_comments per_periods_of_service.comments%TYPE;
1714: ln_person_id per_all_people_f.person_id%TYPE;
1715: ln_period_of_service_id

Line 1712: lv_term_reason per_periods_of_service.leaving_reason%TYPE;

1708: IS
1709: lrt_termination hr_termination_ss.rt_termination;
1710: ld_actual_term_date
1711: per_periods_of_service.actual_termination_date%TYPE;
1712: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1713: ll_term_comments per_periods_of_service.comments%TYPE;
1714: ln_person_id per_all_people_f.person_id%TYPE;
1715: ln_period_of_service_id
1716: per_periods_of_service.period_of_service_id%TYPE;

Line 1713: ll_term_comments per_periods_of_service.comments%TYPE;

1709: lrt_termination hr_termination_ss.rt_termination;
1710: ld_actual_term_date
1711: per_periods_of_service.actual_termination_date%TYPE;
1712: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1713: ll_term_comments per_periods_of_service.comments%TYPE;
1714: ln_person_id per_all_people_f.person_id%TYPE;
1715: ln_period_of_service_id
1716: per_periods_of_service.period_of_service_id%TYPE;
1717: ln_object_version_number

Line 1716: per_periods_of_service.period_of_service_id%TYPE;

1712: lv_term_reason per_periods_of_service.leaving_reason%TYPE;
1713: ll_term_comments per_periods_of_service.comments%TYPE;
1714: ln_person_id per_all_people_f.person_id%TYPE;
1715: ln_period_of_service_id
1716: per_periods_of_service.period_of_service_id%TYPE;
1717: ln_object_version_number
1718: per_periods_of_service.object_version_number%TYPE;
1719: ------------------------------------------------------------------------
1720: -- out parameters required by API actual_termination_emp

Line 1718: per_periods_of_service.object_version_number%TYPE;

1714: ln_person_id per_all_people_f.person_id%TYPE;
1715: ln_period_of_service_id
1716: per_periods_of_service.period_of_service_id%TYPE;
1717: ln_object_version_number
1718: per_periods_of_service.object_version_number%TYPE;
1719: ------------------------------------------------------------------------
1720: -- out parameters required by API actual_termination_emp
1721: ------------------------------------------------------------------------
1722: ld_last_standard_process_date

Line 1723: per_periods_of_service.last_standard_process_date%TYPE;

1719: ------------------------------------------------------------------------
1720: -- out parameters required by API actual_termination_emp
1721: ------------------------------------------------------------------------
1722: ld_last_standard_process_date
1723: per_periods_of_service.last_standard_process_date%TYPE;
1724: ld_notified_term_date
1725: per_periods_of_service.notified_termination_date%TYPE;
1726:
1727: ld_projected_termination_date

Line 1725: per_periods_of_service.notified_termination_date%TYPE;

1721: ------------------------------------------------------------------------
1722: ld_last_standard_process_date
1723: per_periods_of_service.last_standard_process_date%TYPE;
1724: ld_notified_term_date
1725: per_periods_of_service.notified_termination_date%TYPE;
1726:
1727: ld_projected_termination_date
1728: per_periods_of_service.projected_termination_date%TYPE;
1729: ld_final_process_date

Line 1728: per_periods_of_service.projected_termination_date%TYPE;

1724: ld_notified_term_date
1725: per_periods_of_service.notified_termination_date%TYPE;
1726:
1727: ld_projected_termination_date
1728: per_periods_of_service.projected_termination_date%TYPE;
1729: ld_final_process_date
1730: per_periods_of_service.final_process_date%TYPE;
1731:
1732: lb_supervisor_warning BOOLEAN;

Line 1730: per_periods_of_service.final_process_date%TYPE;

1726:
1727: ld_projected_termination_date
1728: per_periods_of_service.projected_termination_date%TYPE;
1729: ld_final_process_date
1730: per_periods_of_service.final_process_date%TYPE;
1731:
1732: lb_supervisor_warning BOOLEAN;
1733: lb_event_warning BOOLEAN;
1734: lb_interview_warning BOOLEAN;

Line 1871: from per_periods_of_service

1867: --------------------------------------------------------------
1868: begin
1869: select business_group_id
1870: into l_business_group_id
1871: from per_periods_of_service
1872: where period_of_service_id = ln_period_of_service_id;
1873: --
1874: l_legislation_code :=
1875: hr_api.return_legislation_code(p_business_group_id => l_business_group_id);