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 5791: FROM per_periods_of_service

5787: CURSOR c_rej_hf_ee (c_per_id IN NUMBER)IS
5788: --9433900
5789: /*
5790: SELECT 1
5791: FROM per_periods_of_service
5792: WHERE PERSON_ID = c_per_id
5793: AND TRUNC(actual_termination_date) =
5794: TRUNC(date_start)
5795: AND NOT EXISTS(SELECT 1

Line 5796: FROM PER_PERIODS_OF_SERVICE

5792: WHERE PERSON_ID = c_per_id
5793: AND TRUNC(actual_termination_date) =
5794: TRUNC(date_start)
5795: AND NOT EXISTS(SELECT 1
5796: FROM PER_PERIODS_OF_SERVICE
5797: WHERE person_id = c_per_id
5798: AND TRUNC(date_start) >
5799: TRUNC(g_extract_params(p_business_group_id).extract_start_date));
5800: */

Line 5802: FROM per_periods_of_service ppos1

5798: AND TRUNC(date_start) >
5799: TRUNC(g_extract_params(p_business_group_id).extract_start_date));
5800: */
5801: SELECT 1
5802: FROM per_periods_of_service ppos1
5803: WHERE ppos1.PERSON_ID = c_per_id
5804: AND TRUNC(ppos1.actual_termination_date) =
5805: TRUNC(ppos1.date_start)
5806: AND TRUNC(ppos1.date_start) <= TRUNC(g_extract_params(p_business_group_id).extract_end_date)

Line 5808: FROM PER_PERIODS_OF_SERVICE ppos2

5804: AND TRUNC(ppos1.actual_termination_date) =
5805: TRUNC(ppos1.date_start)
5806: AND TRUNC(ppos1.date_start) <= TRUNC(g_extract_params(p_business_group_id).extract_end_date)
5807: AND NOT EXISTS(SELECT 1
5808: FROM PER_PERIODS_OF_SERVICE ppos2
5809: WHERE ppos2.person_id = c_per_id
5810: AND ppos1.period_of_service_id <> ppos2.period_of_service_id
5811: AND TRUNC(ppos2.date_start) > TRUNC(ppos1.date_start)
5812: AND TRUNC(g_extract_params(p_business_group_id).extract_end_date) >= TRUNC(ppos2.date_start)

Line 5821: FROM per_periods_of_service pps

5817:
5818: CURSOR c_rej_old_ee (c_ass_id IN NUMBER
5819: ,c_eff_dt IN DATE ) IS
5820: SELECT 1
5821: FROM per_periods_of_service pps
5822: ,per_all_assignments_f asg
5823: WHERE asg.assignment_id = c_ass_id
5824: AND c_eff_dt BETWEEN asg.effective_start_date AND asg.effective_end_date
5825: AND asg.period_of_service_id = pps.period_of_service_id

Line 9393: ,per_periods_of_service pps

9389: -- Cursor to get the hire date of the person
9390: CURSOR c_hire_dt IS
9391: SELECT max(date_start)
9392: FROM per_all_assignments_f asg
9393: ,per_periods_of_service pps
9394: WHERE pps.person_id = asg.person_id
9395: AND asg.assignment_id = p_assignment_id
9396: AND pps.business_group_id = p_business_group_id
9397: AND date_start <= p_effective_date;

Line 9919: ,per_periods_of_service pps

9915: -- Cursor to get the hire date of the person
9916: CURSOR c_hire_dt IS
9917: SELECT max(date_start)
9918: FROM per_all_assignments_f asg
9919: ,per_periods_of_service pps
9920: WHERE pps.person_id = asg.person_id
9921: AND asg.assignment_id = p_assignment_id
9922: AND pps.business_group_id = p_business_group_id
9923: AND date_start <= p_effective_date;

Line 11004: ,per_periods_of_service pps

11000: --
11001: CURSOR c_hire_dt IS
11002: SELECT max(date_start)
11003: FROM per_all_assignments_f asg
11004: ,per_periods_of_service pps
11005: WHERE pps.person_id = asg.person_id
11006: AND asg.assignment_id = p_assignment_id
11007: AND pps.business_group_id = p_business_group_id
11008: AND date_start <= p_effective_date;

Line 11044: FROM per_periods_of_service pps,

11040: -- Bug# 6506736
11041: CURSOR c_get_end_reason IS
11042: SELECT /*decode(nvl(leaving_reason ,'A'),'D','I','A') term_reas*/
11043: decode(nvl(leaving_reason ,'A'),'D','I','B','B','A') term_reas
11044: FROM per_periods_of_service pps,
11045: per_all_assignments_f asg
11046: WHERE asg.period_of_service_id = pps.period_of_service_id
11047: AND assignment_id = p_assignment_id
11048: AND p_effective_date between effective_start_date and

Line 11073: FROM per_periods_of_service

11069: l_hire_ptp_chg c_hire_ptp_chg%ROWTYPE;
11070:
11071: CURSOR c_hf_pos_cur (c_pos_id IN NUMBER)IS
11072: SELECT TRUNC(date_start)
11073: FROM per_periods_of_service
11074: WHERE period_of_service_id = c_pos_id
11075: AND TRUNC(date_start) = trunc(actual_termination_date);
11076:
11077: CURSOR c_prev_term_dt (c_asg_seq_no IN VARCHAR2 ) IS

Line 12309: ,per_periods_of_service pps

12305: -- Cursor to get the hire date of the person
12306: CURSOR c_hire_dt IS
12307: SELECT max(date_start)
12308: FROM per_all_assignments_f asg
12309: ,per_periods_of_service pps
12310: WHERE pps.person_id = asg.person_id
12311: AND asg.assignment_id = p_assignment_id
12312: AND pps.business_group_id = p_business_group_id
12313: AND date_start <= p_effective_date;