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

Line 92: per_periods_of_service pps,

88: ,per.marital_status
89: ,paf.primary_flag
90: FROM per_all_assignments_f paf,
91: per_all_people_f per,
92: per_periods_of_service pps,
93: per_assignment_status_types ast
94: WHERE paf.assignment_id = c_assignment_id
95: AND paf.person_id = per.person_id
96: AND pps.period_of_service_id(+) = paf.period_of_service_id

Line 455: FROM per_periods_of_service pps

451: AND fnd_date.canonical_to_date(prmtr_09) BETWEEN
452: g_extract_params(p_business_group_id).extract_start_date
453: AND g_extract_params(p_business_group_id).extract_end_date
454: AND EXISTS(SELECT 1
455: FROM per_periods_of_service pps
456: ,per_all_assignments_f asg
457: WHERE pps.person_id = g_person_id
458: AND asg.assignment_id = p_assignment_id
459: AND asg.period_of_service_id = pps.period_of_service_id

Line 529: ,per_periods_of_service pps

525: ,to_char(pps.actual_termination_date,'DD/MM/YYYY') term_date
526: ,ext_chg_evt_log_id
527: ,fnd_number.canonical_to_number(prmtr_01)
528: FROM ben_ext_chg_evt_log bec
529: ,per_periods_of_service pps
530: ,per_all_assignments_f asg
531: WHERE bec.chg_evt_cd = 'AAT'
532: AND bec.person_id = g_person_id
533: AND bec.business_group_id = p_business_group_id

Line 5600: FROM per_periods_of_service

5596: ORDER BY rin.seq_num;
5597:
5598: CURSOR c_rej_hf_ee (c_per_id IN NUMBER)IS
5599: SELECT 1
5600: FROM per_periods_of_service
5601: WHERE PERSON_ID = c_per_id
5602: AND TRUNC(actual_termination_date) =
5603: TRUNC(date_start)
5604: AND NOT EXISTS(SELECT 1

Line 5605: FROM PER_PERIODS_OF_SERVICE

5601: WHERE PERSON_ID = c_per_id
5602: AND TRUNC(actual_termination_date) =
5603: TRUNC(date_start)
5604: AND NOT EXISTS(SELECT 1
5605: FROM PER_PERIODS_OF_SERVICE
5606: WHERE person_id = c_per_id
5607: AND TRUNC(date_start) >
5608: TRUNC(g_extract_params(p_business_group_id).extract_start_date));
5609:

Line 5613: FROM per_periods_of_service pps

5609:
5610: CURSOR c_rej_old_ee (c_ass_id IN NUMBER
5611: ,c_eff_dt IN DATE ) IS
5612: SELECT 1
5613: FROM per_periods_of_service pps
5614: ,per_all_assignments_f asg
5615: WHERE asg.assignment_id = c_ass_id
5616: AND c_eff_dt BETWEEN asg.effective_start_date AND asg.effective_end_date
5617: AND asg.period_of_service_id = pps.period_of_service_id

Line 9054: ,per_periods_of_service pps

9050: -- Cursor to get the hire date of the person
9051: CURSOR c_hire_dt IS
9052: SELECT max(date_start)
9053: FROM per_all_assignments_f asg
9054: ,per_periods_of_service pps
9055: WHERE pps.person_id = asg.person_id
9056: AND asg.assignment_id = p_assignment_id
9057: AND pps.business_group_id = p_business_group_id
9058: AND date_start <= p_effective_date;

Line 9580: ,per_periods_of_service pps

9576: -- Cursor to get the hire date of the person
9577: CURSOR c_hire_dt IS
9578: SELECT max(date_start)
9579: FROM per_all_assignments_f asg
9580: ,per_periods_of_service pps
9581: WHERE pps.person_id = asg.person_id
9582: AND asg.assignment_id = p_assignment_id
9583: AND pps.business_group_id = p_business_group_id
9584: AND date_start <= p_effective_date;

Line 10665: ,per_periods_of_service pps

10661: --
10662: CURSOR c_hire_dt IS
10663: SELECT max(date_start)
10664: FROM per_all_assignments_f asg
10665: ,per_periods_of_service pps
10666: WHERE pps.person_id = asg.person_id
10667: AND asg.assignment_id = p_assignment_id
10668: AND pps.business_group_id = p_business_group_id
10669: AND date_start <= p_effective_date;

Line 10705: FROM per_periods_of_service pps,

10701: -- Bug# 6506736
10702: CURSOR c_get_end_reason IS
10703: SELECT /*decode(nvl(leaving_reason ,'A'),'D','I','A') term_reas*/
10704: decode(nvl(leaving_reason ,'A'),'D','I','B','B','A') term_reas
10705: FROM per_periods_of_service pps,
10706: per_all_assignments_f asg
10707: WHERE asg.period_of_service_id = pps.period_of_service_id
10708: AND assignment_id = p_assignment_id
10709: AND p_effective_date between effective_start_date and

Line 10734: FROM per_periods_of_service

10730: l_hire_ptp_chg c_hire_ptp_chg%ROWTYPE;
10731:
10732: CURSOR c_hf_pos_cur (c_pos_id IN NUMBER)IS
10733: SELECT TRUNC(date_start)
10734: FROM per_periods_of_service
10735: WHERE period_of_service_id = c_pos_id
10736: AND TRUNC(date_start) = trunc(actual_termination_date);
10737:
10738: CURSOR c_prev_term_dt (c_asg_seq_no IN VARCHAR2 ) IS

Line 11940: ,per_periods_of_service pps

11936: -- Cursor to get the hire date of the person
11937: CURSOR c_hire_dt IS
11938: SELECT max(date_start)
11939: FROM per_all_assignments_f asg
11940: ,per_periods_of_service pps
11941: WHERE pps.person_id = asg.person_id
11942: AND asg.assignment_id = p_assignment_id
11943: AND pps.business_group_id = p_business_group_id
11944: AND date_start <= p_effective_date;