APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PAY_PAYROLLS_F

Line 1049: l_payroll_id pay_payrolls_f.payroll_id%type;

1045: l_noa_code ghr_pa_requests.first_noa_code%type;
1046: l_fegli ghr_pa_requests.fegli%type;
1047: l_prev_fegli ghr_pa_requests.fegli%type;
1048: l_scd ghr_pa_requests.SERVICE_COMP_DATE%type;
1049: l_payroll_id pay_payrolls_f.payroll_id%type;
1050: l_pa_request_id ghr_pa_requests.pa_request_id%type;
1051: l_effective_date ghr_pa_requests.effective_date%type;
1052: l_start_date per_time_periods.start_date%type;
1053: l_family_code ghr_pa_requests.noa_family_code%type;

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

1074: FROM ghr_pa_request_extra_info
1075: WHERE pa_request_id = c_pa_request_id
1076: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
1077:
1078: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS
1079: SELECT min(start_date) start_date
1080: FROM per_time_periods
1081: WHERE payroll_id = c_payroll_id
1082: AND TO_CHAR(start_date,'YYYY') = c_year

Line 3566: from pay_payrolls_f pay

3562: where pa_request_id = p_pa_request_id;
3563:
3564: Cursor c_def_payroll is
3565: select pay.payroll_id
3566: from pay_payrolls_f pay
3567: where payroll_name = 'Biweekly'
3568: and nvl(p_effective_date,sysdate) between
3569: pay.effective_start_date and pay.effective_end_date
3570: and business_group_id = l_business_group_id;