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

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

2147: l_table_name(i) := 'PER_ALL_PEOPLE_F';
2148: i := i + 1;
2149: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';
2150: i := i + 1;
2151: l_table_name(i) := 'PER_PERIODS_OF_SERVICE';
2152: i := i + 1;
2153: l_table_name(i) := 'PQP_GAP_DURATION_SUMMARY';
2154:
2155: WHILE i > 0

Line 2724: FROM per_all_people_f per, per_periods_of_service pps

2720: -- Cursor to get latest start date
2721: CURSOR csr_get_latest_date
2722: IS
2723: SELECT DECODE(per.current_employee_flag, 'Y', pps.date_start, NULL)
2724: FROM per_all_people_f per, per_periods_of_service pps
2725: WHERE per.person_id = p_person_id
2726: AND pps.person_id = p_person_id
2727: AND p_effective_date BETWEEN per.effective_start_date
2728: AND NVL(

Line 3360: FROM per_periods_of_service pps

3356: CURSOR csr_get_leaving_reason(c_person_id NUMBER
3357: ,c_effective_date DATE)
3358: IS
3359: SELECT pps.leaving_reason, pps.actual_termination_date
3360: FROM per_periods_of_service pps
3361: WHERE pps.person_id = c_person_id
3362: AND pps.date_start = (SELECT MAX(date_start)
3363: FROM per_periods_of_service pps1
3364: WHERE pps1.person_id = c_person_id

Line 3363: FROM per_periods_of_service pps1

3359: SELECT pps.leaving_reason, pps.actual_termination_date
3360: FROM per_periods_of_service pps
3361: WHERE pps.person_id = c_person_id
3362: AND pps.date_start = (SELECT MAX(date_start)
3363: FROM per_periods_of_service pps1
3364: WHERE pps1.person_id = c_person_id
3365: AND pps1.date_start <= c_effective_date);
3366:
3367: --For bug 7705147: Cursor to get Actual Termination Date

Line 3372: per_periods_of_service pos

3368: CURSOR csr_get_atd
3369: IS
3370: SELECT pos.actual_termination_date
3371: FROM per_all_assignments_f asg,
3372: per_periods_of_service pos
3373: WHERE asg.assignment_id = p_assignment_id
3374: AND g_effective_date between asg.effective_start_date AND asg.effective_end_date
3375: AND asg.period_of_service_id = pos.period_of_service_id;
3376:

Line 4552: per_periods_of_service pos

4548: CURSOR csr_get_term_date
4549: IS
4550: SELECT actual_termination_date
4551: FROM per_all_assignments_f paf,
4552: per_periods_of_service pos
4553: WHERE paf.assignment_id=p_assignment_id
4554: AND paf.period_of_service_id = pos.period_of_service_id;
4555:
4556:

Line 4801: per_periods_of_service pos

4797: CURSOR csr_get_act_term_date
4798: IS
4799: SELECT actual_termination_date
4800: FROM per_all_assignments_f paf,
4801: per_periods_of_service pos
4802: WHERE paf.assignment_id=p_assignment_id
4803: AND paf.period_of_service_id = pos.period_of_service_id;
4804: --For Bug 6972649 till here
4805:

Line 5182: per_periods_of_service pps,

5178: CURSOR csr_get_asg_details
5179: IS
5180: SELECT effective_end_date
5181: FROM per_all_assignments_f paaf,
5182: per_periods_of_service pps,
5183: per_assignment_status_types past
5184: WHERE paaf.assignment_id = p_assignment_id
5185: AND paaf.assignment_status_type_id = past.assignment_status_type_id
5186: and pps.person_id = paaf.person_id

Line 5860: per_periods_of_service pos

5856:
5857: CURSOR csr_get_ser_details IS --in 115.21 5945283
5858: SELECT leaving_reason, actual_termination_date,final_process_date
5859: FROM per_all_assignments_f paf,
5860: per_periods_of_service pos
5861: WHERE paf.assignment_id=p_assignment_id
5862: AND paf.period_of_service_id = pos.period_of_service_id;
5863: --date join not required as all rows will have same data.
5864:

Line 5871: FROM per_periods_of_service pps

5867: CURSOR csr_get_leaving_reason(c_person_id NUMBER
5868: ,c_effective_date DATE)
5869: IS
5870: SELECT pps.leaving_reason, pps.actual_termination_date
5871: FROM per_periods_of_service pps
5872: WHERE pps.person_id = c_person_id
5873: AND pps.date_start = (SELECT MAX(date_start)
5874: FROM per_periods_of_service pps1
5875: WHERE pps1.person_id = c_person_id

Line 5874: FROM per_periods_of_service pps1

5870: SELECT pps.leaving_reason, pps.actual_termination_date
5871: FROM per_periods_of_service pps
5872: WHERE pps.person_id = c_person_id
5873: AND pps.date_start = (SELECT MAX(date_start)
5874: FROM per_periods_of_service pps1
5875: WHERE pps1.person_id = c_person_id
5876: AND pps1.date_start <= c_effective_date);
5877:
5878: --For bug 7013325:Start

Line 6302: IF l_table_name = 'PER_PERIODS_OF_SERVICE'

6298: THEN
6299: -- This is a leaver event
6300: -- Ensure that the assignment status represents
6301: -- Termination as of the event date
6302: IF l_table_name = 'PER_PERIODS_OF_SERVICE'
6303: THEN
6304: --115.21 5945283
6305: /* l_period_of_service_id :=
6306: fnd_number.canonical_to_number(