APPS.GHR_SF52_DO_UPDATE dependencies on PAY_PAYROLLS_F

Line 2970: l_payroll_id pay_payrolls_f.payroll_id%type;

2966: l_employee_update_flag varchar2(1) := 'N';
2967: l_update_gre varchar2(1) := 'N';
2968: l_rehire_ex_emp varchar2(1 ) := 'N';
2969: l_period_of_service_id number;
2970: l_payroll_id pay_payrolls_f.payroll_id%type;
2971: l_payroll_name pay_payrolls_f.payroll_name%type;
2972: l_business_group_id per_people_f.business_group_id%type;
2973: l_orig_hire_warning boolean;
2974:

Line 2971: l_payroll_name pay_payrolls_f.payroll_name%type;

2967: l_update_gre varchar2(1) := 'N';
2968: l_rehire_ex_emp varchar2(1 ) := 'N';
2969: l_period_of_service_id number;
2970: l_payroll_id pay_payrolls_f.payroll_id%type;
2971: l_payroll_name pay_payrolls_f.payroll_name%type;
2972: l_business_group_id per_people_f.business_group_id%type;
2973: l_orig_hire_warning boolean;
2974:
2975: l_working_hours per_assignments_f.normal_hours%type;

Line 3221: from pay_payrolls_f

3217: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
3218:
3219: Cursor c_payroll_id is
3220: select payroll_id
3221: from pay_payrolls_f
3222: where period_type = 'Bi-Week'
3223: and payroll_name = l_payroll_name
3224: and business_group_id = l_business_group_id
3225: and p_pa_request_rec.effective_date

Line 3230: from pay_payrolls_f pay

3226: between effective_start_date and effective_end_date;
3227:
3228: Cursor c_bw_payroll is
3229: select pay.payroll_id
3230: from pay_payrolls_f pay
3231: where pay.payroll_name = 'Biweekly Payroll'
3232: and g_effective_date
3233: between pay.effective_start_date and pay.effective_end_date
3234: and business_group_id = l_business_group_id;

Line 7854: l_payroll_id pay_payrolls_f.payroll_id%type;

7850: is
7851:
7852: l_proc varchar2(72) := 'get_wgi_dates';
7853: l_initial_wgi_due_date date;
7854: l_payroll_id pay_payrolls_f.payroll_id%type;
7855: l_eq_pay_plan ghr_pay_plans.pay_plan%type;
7856: l_from_step ghr_pa_requests.to_step_or_rate%type;
7857: l_wgi_due_Date varchar2(60);
7858: l_wgi_pay_date date;