APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on STANDARD

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

1334: AND paaf.assignment_id = p_assignment_id
1335: AND ptp.end_date >= p_effective_start_date ;
1336:
1337: -- TERM_LSP:BUG 4135481: added a cursor to fetch
1338: -- Last Standard Process Date and Final Close Date
1339: -- for terminated employees
1340:
1341: CURSOR csr_get_termination_details
1342: (p_assignment_id NUMBER

Line 1350: ,pps.last_standard_process_date last_standard_process_date

1346: IS
1347: SELECT paa.assignment_id assignment_id
1348: ,pps.date_start start_date
1349: ,pps.actual_termination_date actual_termination_date
1350: ,pps.last_standard_process_date last_standard_process_date
1351: ,pps.final_process_date final_process_date
1352: FROM per_periods_of_service_v pps
1353: ,per_all_assignments_f paa
1354: WHERE paa.person_id = pps.person_id

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

1356: AND paa.effective_end_date = pps.actual_termination_date
1357: AND pps.date_start <= p_effective_end_date
1358: AND pps.business_group_id = nvl(p_business_group_id,g_business_group_id)
1359: -- following condn no longer mandatory as LSP date and Final Close Date can be left Null.
1360: --AND pps.actual_termination_date <> pps.last_standard_process_date
1361: AND pps.actual_termination_date = p_effective_end_date
1362: ORDER BY pps.date_start DESC;
1363:
1364: --