APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_PAYROLLS_F

Line 1187: l_payroll_id pay_payrolls_f.payroll_id%type;

1183: l_noa_code ghr_pa_requests.first_noa_code%type;
1184: l_fegli ghr_pa_requests.fegli%type;
1185: l_prev_fegli ghr_pa_requests.fegli%type;
1186: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1187: l_payroll_id pay_payrolls_f.payroll_id%type;
1188: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1189: l_effective_date ghr_pa_requests.effective_date%type;
1190: l_start_date per_time_periods.start_date%type;
1191: l_family_code ghr_pa_requests.noa_family_code%type;

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

1216: FROM ghr_pa_request_extra_info
1217: WHERE pa_request_id = c_pa_request_id
1218: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
1219:
1220: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS
1221: SELECT min(start_date) start_date
1222: FROM per_time_periods
1223: WHERE payroll_id = c_payroll_id
1224: AND TO_CHAR(start_date,'YYYY') = c_year

Line 4323: from pay_payrolls_f pay

4319: where pa_request_id = p_pa_request_id;
4320:
4321: Cursor c_def_payroll is
4322: select pay.payroll_id
4323: from pay_payrolls_f pay
4324: where payroll_name = 'Biweekly'
4325: and nvl(p_effective_date,sysdate) between
4326: pay.effective_start_date and pay.effective_end_date
4327: and business_group_id = l_business_group_id;