DBA Data[Home] [Help]

APPS.GHR_PAR_EXTRA_INFO_API dependencies on PAY_PAYROLLS_F

Line 932: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS

928: FROM ghr_pa_request_extra_info
929: WHERE pa_request_id = c_pa_request_id
930: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
931:
932: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS
933: SELECT min(start_date) start_date
934: FROM per_time_periods
935: WHERE payroll_id = c_payroll_id
936: AND TO_CHAR(start_date,'YYYY') = c_year