APPS.PSP_RBKPAY dependencies on PER_TIME_PERIODS

Line 9: -- from per_time_periods based on time period id

5: p_period_type IN VARCHAR2 ,
6: p_time_period_id IN NUMBER) IS
7:
8: -- Get Payroll start date , end date, payroll id
9: -- from per_time_periods based on time period id
10:
11: CURSOR get_payroll_id_csr is
12: SELECT start_date, end_date, payroll_id
13: FROM per_time_periods

Line 13: FROM per_time_periods

9: -- from per_time_periods based on time period id
10:
11: CURSOR get_payroll_id_csr is
12: SELECT start_date, end_date, payroll_id
13: FROM per_time_periods
14: WHERE time_period_id = p_time_period_id ;
15:
16: CURSOR get_payroll_control_id_csr is
17: SELECT payroll_control_id, status_code, dist_cr_amount,dist_dr_amount