DBA Data[Home] [Help]

APPS.PQP_US_SRS_EXTRACTS dependencies on PER_TIME_PERIODS

Line 155: from per_time_periods

151: -- different payroll frequency i.e. Monthly, Semi-Month, Weekly etc..
152: Cursor csr_time_period ( c_payroll_id In pay_payrolls_f.payroll_id%TYPE
153: ,c_effective_date In date) Is
154: Select start_date, end_date
155: from per_time_periods
156: where payroll_id = c_payroll_id
157: and c_effective_date between start_date
158: and end_date;
159: --