DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_TIME_PERIODS

Line 1018: FROM per_time_periods ptp

1014: -- ============================================================================
1015: CURSOR c_get_retro_time_period(c_element_entry_id in number
1016: ,c_assignment_id in number) IS
1017: SELECT ptp.start_date,ptp.end_date
1018: FROM per_time_periods ptp
1019: ,per_all_assignments_f paa
1020: WHERE paa.assignment_id = c_assignment_id
1021: AND ptp.payroll_id = paa.payroll_id
1022: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)