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_JP_UITE_ARCH_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 689: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE

685: PROCEDURE proc_insert_row( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
686: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
687: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
688: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
689: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
690: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
691: ,p_hire_date IN per_periods_of_service.date_start%TYPE
692: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE
693: ,p_line_number OUT NOCOPY NUMBER)

Line 691: ,p_hire_date IN per_periods_of_service.date_start%TYPE

687: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
688: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
689: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
690: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
691: ,p_hire_date IN per_periods_of_service.date_start%TYPE
692: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE
693: ,p_line_number OUT NOCOPY NUMBER)
694: IS
695: --***************************************************************************

Line 692: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE

688: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
689: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
690: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
691: ,p_hire_date IN per_periods_of_service.date_start%TYPE
692: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE
693: ,p_line_number OUT NOCOPY NUMBER)
694: IS
695: --***************************************************************************
696: -- PROCEDURE

Line 881: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE

877: PROCEDURE proc_sal_arch( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
878: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
879: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
880: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
881: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
882: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
883: ,p_hire_date IN per_periods_of_service.date_start%TYPE
884: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE
885: ,p_ins_start_date OUT NOCOPY per_time_periods.start_date%TYPE)

Line 883: ,p_hire_date IN per_periods_of_service.date_start%TYPE

879: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
880: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
881: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
882: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
883: ,p_hire_date IN per_periods_of_service.date_start%TYPE
884: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE
885: ,p_ins_start_date OUT NOCOPY per_time_periods.start_date%TYPE)
886: --***************************************************************************
887: -- PROCEDURE

Line 884: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE

880: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
881: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
882: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
883: ,p_hire_date IN per_periods_of_service.date_start%TYPE
884: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE
885: ,p_ins_start_date OUT NOCOPY per_time_periods.start_date%TYPE)
886: --***************************************************************************
887: -- PROCEDURE
888: -- proc_sal_arch

Line 1891: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE

1887: PROCEDURE proc_term_arch( p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1888: ,p_payroll_action_id IN pay_payroll_actions.payroll_action_id%TYPE
1889: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1890: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
1891: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
1892: )
1893: --***************************************************************************
1894: -- PROCEDURE
1895: -- proc_sal_arch

Line 2408: ,per_periods_of_service PPS

2404: ,PPS.actual_termination_date
2405: ,PPS.projected_termination_date
2406: FROM per_people_f PPF
2407: ,per_assignments_f PAF
2408: ,per_periods_of_service PPS
2409: ,pay_population_ranges PPR
2410: ,pay_payroll_actions PPA
2411: WHERE PPF.person_id = PAF.person_id
2412: AND PPF.person_id = PPS.person_id

Line 2444: ,per_periods_of_service PPS

2440: ,PPS.actual_termination_date
2441: ,PPS.projected_termination_date
2442: FROM per_people_f PPF
2443: ,per_assignments_f PAF
2444: ,per_periods_of_service PPS
2445: WHERE PPF.person_id = PAF.person_id
2446: AND PPF.person_id = PPS.person_id
2447: AND PAF.business_group_id = p_business_group_id
2448: AND PPF.person_id BETWEEN p_start_person_id

Line 2681: , per_periods_of_service PPOS

2677: , PPOS.last_standard_process_date LAST_STD_PROCESS_DATE
2678: FROM per_people_f PPF
2679: , per_assignments_f PAF
2680: , per_addresses PAD
2681: , per_periods_of_service PPOS
2682: WHERE PAF.person_id = PPF.person_id
2683: AND PAD.person_id(+) = PPF.person_id
2684: AND PAD.address_type(+) = 'JP_C'
2685: AND TRUNC(NVL(PPOS.actual_termination_date,PPOS.projected_termination_date)) BETWEEN NVL(PAD.date_from,NVL(PPOS.actual_termination_date,PPOS.projected_termination_date))