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

Line 67: per_periods_of_service pps,

63: ,per.marital_status
64: ,paf.primary_flag
65: FROM per_all_assignments_f paf,
66: per_all_people_f per,
67: per_periods_of_service pps,
68: per_assignment_status_types ast
69: WHERE paf.assignment_id = c_assignment_id
70: AND paf.person_id = per.person_id
71: AND pps.period_of_service_id(+) = paf.period_of_service_id

Line 3688: ,per_periods_of_service pps

3684: -- Cursor to get the hire date of the person
3685: /*Cursor csr_get_hire_date IS
3686: SELECT max(date_start)
3687: FROM per_all_assignments_f asg
3688: ,per_periods_of_service pps
3689: WHERE pps.person_id = asg.person_id
3690: AND asg.assignment_id = p_assignment_id
3691: AND pps.business_group_id = p_business_group_id
3692: AND date_start <= p_effective_date;*/

Line 3743: FROM per_periods_of_service pps,

3739: --
3740: CURSOR c_get_end_reason_new IS
3741: SELECT SUBSTR(DECODE(NVL(leaving_reason,'OVE'),'D','OVL'
3742: ,NVL(leaving_reason,'OVE')),1,3)
3743: FROM per_periods_of_service pps,
3744: per_all_assignments_f asg
3745: WHERE asg.period_of_service_id = pps.period_of_service_id
3746: AND assignment_id = p_assignment_id
3747: AND p_effective_date BETWEEN effective_start_date AND

Line 4048: ,per_periods_of_service pps

4044: Return Number IS
4045: /*CURSOR csr_get_assgn_end_date(c_assignment_id NUMBER) IS
4046: SELECT max(actual_termination_date)
4047: FROM per_all_assignments_f asg
4048: ,per_periods_of_service pps
4049: WHERE pps.person_id = asg.person_id
4050: AND asg.assignment_id = c_assignment_id
4051: AND pps.business_group_id = p_business_group_id
4052: AND date_start <= p_effective_date;

Line 5470: SELECT 1 FROM per_periods_of_service

5466: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
5467: ,p_effective_date IN DATE
5468: ) RETURN Number IS
5469: CURSOR cur_chk_term IS
5470: SELECT 1 FROM per_periods_of_service
5471: WHERE PERSON_ID = g_person_id
5472: AND TRUNC(actual_termination_date) <= trunc(p_effective_date)
5473: AND NOT EXISTS ( SELECT 1 FROM PER_PERIODS_OF_SERVICE
5474: WHERE person_id = g_person_id

Line 5473: AND NOT EXISTS ( SELECT 1 FROM PER_PERIODS_OF_SERVICE

5469: CURSOR cur_chk_term IS
5470: SELECT 1 FROM per_periods_of_service
5471: WHERE PERSON_ID = g_person_id
5472: AND TRUNC(actual_termination_date) <= trunc(p_effective_date)
5473: AND NOT EXISTS ( SELECT 1 FROM PER_PERIODS_OF_SERVICE
5474: WHERE person_id = g_person_id
5475: AND trunc(date_start) BETWEEN trunc(p_effective_date)
5476: AND add_months(trunc(p_effective_date),1) - 1
5477: AND actual_termination_date is null) ;