DBA Data[Home] [Help]

APPS.PQP_NL_PENSION_EXTRACTS dependencies on PER_TIME_PERIODS

Line 999: FROM per_time_periods ptp

995: -- ============================================================================
996: CURSOR c_get_retro_time_period(c_element_entry_id in number
997: ,c_assignment_id in number) IS
998: SELECT ptp.start_date,ptp.end_date
999: FROM per_time_periods ptp
1000: ,per_all_assignments_f paa
1001: WHERE paa.assignment_id = c_assignment_id
1002: AND ptp.payroll_id = paa.payroll_id
1003: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)