APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PER_PERIODS_OF_SERVICE

Line 2133: l_table_name(i) := 'PER_PERIODS_OF_SERVICE';

2129: l_table_name(i) := 'PER_ALL_PEOPLE_F';
2130: i := i + 1;
2131: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';
2132: i := i + 1;
2133: l_table_name(i) := 'PER_PERIODS_OF_SERVICE';
2134: i := i + 1;
2135: l_table_name(i) := 'PQP_GAP_DURATION_SUMMARY';
2136:
2137: WHILE i > 0

Line 2706: FROM per_all_people_f per, per_periods_of_service pps

2702: -- Cursor to get latest start date
2703: CURSOR csr_get_latest_date
2704: IS
2705: SELECT DECODE(per.current_employee_flag, 'Y', pps.date_start, NULL)
2706: FROM per_all_people_f per, per_periods_of_service pps
2707: WHERE per.person_id = p_person_id
2708: AND pps.person_id = p_person_id
2709: AND p_effective_date BETWEEN per.effective_start_date
2710: AND NVL(

Line 3342: FROM per_periods_of_service pps

3338: CURSOR csr_get_leaving_reason(c_person_id NUMBER
3339: ,c_effective_date DATE)
3340: IS
3341: SELECT pps.leaving_reason, pps.actual_termination_date
3342: FROM per_periods_of_service pps
3343: WHERE pps.person_id = c_person_id
3344: AND pps.date_start = (SELECT MAX(date_start)
3345: FROM per_periods_of_service pps1
3346: WHERE pps1.person_id = c_person_id

Line 3345: FROM per_periods_of_service pps1

3341: SELECT pps.leaving_reason, pps.actual_termination_date
3342: FROM per_periods_of_service pps
3343: WHERE pps.person_id = c_person_id
3344: AND pps.date_start = (SELECT MAX(date_start)
3345: FROM per_periods_of_service pps1
3346: WHERE pps1.person_id = c_person_id
3347: AND pps1.date_start <= c_effective_date);
3348:
3349: l_proc_name VARCHAR2(80)

Line 4498: per_periods_of_service pos

4494: CURSOR csr_get_term_date
4495: IS
4496: SELECT actual_termination_date
4497: FROM per_all_assignments_f paf,
4498: per_periods_of_service pos
4499: WHERE paf.assignment_id=p_assignment_id
4500: AND paf.period_of_service_id = pos.period_of_service_id;
4501:
4502:

Line 4747: per_periods_of_service pos

4743: CURSOR csr_get_act_term_date
4744: IS
4745: SELECT actual_termination_date
4746: FROM per_all_assignments_f paf,
4747: per_periods_of_service pos
4748: WHERE paf.assignment_id=p_assignment_id
4749: AND paf.period_of_service_id = pos.period_of_service_id;
4750: --For Bug 6972649 till here
4751:

Line 5128: per_periods_of_service pps,

5124: CURSOR csr_get_asg_details
5125: IS
5126: SELECT effective_end_date
5127: FROM per_all_assignments_f paaf,
5128: per_periods_of_service pps,
5129: per_assignment_status_types past
5130: WHERE paaf.assignment_id = p_assignment_id
5131: AND paaf.assignment_status_type_id = past.assignment_status_type_id
5132: and pps.person_id = paaf.person_id

Line 5798: per_periods_of_service pos

5794:
5795: CURSOR csr_get_ser_details IS --in 115.21 5945283
5796: SELECT leaving_reason, actual_termination_date,final_process_date
5797: FROM per_all_assignments_f paf,
5798: per_periods_of_service pos
5799: WHERE paf.assignment_id=p_assignment_id
5800: AND paf.period_of_service_id = pos.period_of_service_id;
5801: --date join not required as all rows will have same data.
5802:

Line 5809: FROM per_periods_of_service pps

5805: CURSOR csr_get_leaving_reason(c_person_id NUMBER
5806: ,c_effective_date DATE)
5807: IS
5808: SELECT pps.leaving_reason, pps.actual_termination_date
5809: FROM per_periods_of_service pps
5810: WHERE pps.person_id = c_person_id
5811: AND pps.date_start = (SELECT MAX(date_start)
5812: FROM per_periods_of_service pps1
5813: WHERE pps1.person_id = c_person_id

Line 5812: FROM per_periods_of_service pps1

5808: SELECT pps.leaving_reason, pps.actual_termination_date
5809: FROM per_periods_of_service pps
5810: WHERE pps.person_id = c_person_id
5811: AND pps.date_start = (SELECT MAX(date_start)
5812: FROM per_periods_of_service pps1
5813: WHERE pps1.person_id = c_person_id
5814: AND pps1.date_start <= c_effective_date);
5815:
5816: --For bug 7013325:Start

Line 6240: IF l_table_name = 'PER_PERIODS_OF_SERVICE'

6236: THEN
6237: -- This is a leaver event
6238: -- Ensure that the assignment status represents
6239: -- Termination as of the event date
6240: IF l_table_name = 'PER_PERIODS_OF_SERVICE'
6241: THEN
6242: --115.21 5945283
6243: /* l_period_of_service_id :=
6244: fnd_number.canonical_to_number(