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

Line 2415: FROM per_periods_of_service ppos1

2411: --hired and terminated on the same date and then again re-hired
2412: CURSOR csr_rehire_chk(c_per_id IN NUMBER
2413: ,c_end_date IN DATE)IS
2414: SELECT 1
2415: FROM per_periods_of_service ppos1
2416: WHERE ppos1.person_id = c_per_id
2417: AND trunc (ppos1.actual_termination_date) = trunc (ppos1.date_start)
2418: AND trunc (ppos1.date_start) <= c_end_date
2419: AND NOT EXISTS

Line 2422: FROM per_periods_of_service ppos2

2418: AND trunc (ppos1.date_start) <= c_end_date
2419: AND NOT EXISTS
2420: (
2421: SELECT 1
2422: FROM per_periods_of_service ppos2
2423: WHERE ppos2.person_id = c_per_id
2424: AND ppos1.period_of_service_id <> ppos2.period_of_service_id
2425: AND trunc (ppos2.date_start) > trunc (ppos1.date_start)
2426: AND c_end_date >= trunc (ppos2.date_start)

Line 2437: FROM per_periods_of_service pps

2433: CURSOR csr_term_chk(c_asg_id IN NUMBER
2434: ,c_bg_id IN NUMBER
2435: ,c_start_date IN DATE) IS
2436: SELECT 1
2437: FROM per_periods_of_service pps
2438: ,per_all_assignments_f asg
2439: WHERE asg.assignment_id = c_asg_id
2440: --AND c_effective_date BETWEEN asg.effective_start_date
2441: -- AND asg.effective_end_date

Line 3099: FROM per_periods_of_service pps

3095: ,'B' ,'A'
3096: ,'RESIGNATION' ,'W'
3097: ,'EARLY_RETIREMENT' ,'V'
3098: ,'R') term_reas
3099: FROM per_periods_of_service pps
3100: ,per_all_assignments_f paaf
3101: WHERE paaf.period_of_service_id = pps.period_of_service_id
3102: AND paaf.assignment_id = c_assignment_id
3103: AND c_effective_date BETWEEN paaf.effective_start_date

Line 3314: l_term_reason per_periods_of_service.leaving_reason%TYPE;

3310: l_asg_start_date DATE;
3311: l_asg_end_date DATE;
3312: l_asg_term_date DATE:=NULL;
3313: l_term_pos_id NUMBER:=NULL;
3314: l_term_reason per_periods_of_service.leaving_reason%TYPE;
3315: l_pension_salary NUMBER := 0;
3316: l_ptp NUMBER := 0;
3317: l_empty_pay_period VARCHAR2(3):='ja';
3318: l_part_details csr_part_details%ROWTYPE;