APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on STANDARD

Line 1359: -- Last Standard Process Date and Final Close Date

1355: AND paaf.assignment_id = p_assignment_id
1356: AND ptp.end_date >= p_effective_start_date ;
1357:
1358: -- TERM_LSP:BUG 4135481: added a cursor to fetch
1359: -- Last Standard Process Date and Final Close Date
1360: -- for terminated employees
1361:
1362: CURSOR csr_get_termination_details
1363: (p_assignment_id NUMBER

Line 1371: ,pps.last_standard_process_date last_standard_process_date

1367: IS
1368: SELECT paa.assignment_id assignment_id
1369: ,pps.date_start start_date
1370: ,pps.actual_termination_date actual_termination_date
1371: ,pps.last_standard_process_date last_standard_process_date
1372: ,pps.final_process_date final_process_date
1373: FROM per_periods_of_service_v pps
1374: ,per_all_assignments_f paa
1375: WHERE paa.person_id = pps.person_id

Line 1381: --AND pps.actual_termination_date <> pps.last_standard_process_date

1377: AND paa.effective_end_date = pps.actual_termination_date
1378: AND pps.date_start <= p_effective_end_date
1379: AND pps.business_group_id = nvl(p_business_group_id,g_business_group_id)
1380: -- following condn no longer mandatory as LSP date and Final Close Date can be left Null.
1381: --AND pps.actual_termination_date <> pps.last_standard_process_date
1382: AND pps.actual_termination_date = p_effective_end_date
1383: ORDER BY pps.date_start DESC;
1384:
1385: --