APPS.GHR_SF52_DO_UPDATE dependencies on PAY_PAYROLLS_F

Line 3174: l_payroll_id pay_payrolls_f.payroll_id%type;

3170: l_employee_update_flag varchar2(1) := 'N';
3171: l_update_gre varchar2(1) := 'N';
3172: l_rehire_ex_emp varchar2(1 ) := 'N';
3173: l_period_of_service_id number;
3174: l_payroll_id pay_payrolls_f.payroll_id%type;
3175: l_payroll_name pay_payrolls_f.payroll_name%type;
3176: l_business_group_id per_people_f.business_group_id%type;
3177: l_orig_hire_warning boolean;
3178:

Line 3175: l_payroll_name pay_payrolls_f.payroll_name%type;

3171: l_update_gre varchar2(1) := 'N';
3172: l_rehire_ex_emp varchar2(1 ) := 'N';
3173: l_period_of_service_id number;
3174: l_payroll_id pay_payrolls_f.payroll_id%type;
3175: l_payroll_name pay_payrolls_f.payroll_name%type;
3176: l_business_group_id per_people_f.business_group_id%type;
3177: l_orig_hire_warning boolean;
3178:
3179: l_working_hours per_assignments_f.normal_hours%type;

Line 3426: from pay_payrolls_f

3422: and information_type = 'GHR_US_PAR_PAYROLL_TYPE';
3423:
3424: Cursor c_payroll_id is
3425: select payroll_id
3426: from pay_payrolls_f
3427: where period_type = 'Bi-Week'
3428: and payroll_name = l_payroll_name
3429: and business_group_id = l_business_group_id
3430: and p_pa_request_rec.effective_date

Line 3435: from pay_payrolls_f pay

3431: between effective_start_date and effective_end_date;
3432:
3433: Cursor c_bw_payroll is
3434: select pay.payroll_id
3435: from pay_payrolls_f pay
3436: where pay.payroll_name = 'Biweekly Payroll'
3437: and g_effective_date
3438: between pay.effective_start_date and pay.effective_end_date
3439: and business_group_id = l_business_group_id;

Line 8157: l_payroll_id pay_payrolls_f.payroll_id%type;

8153: is
8154:
8155: l_proc varchar2(72) := 'get_wgi_dates';
8156: l_initial_wgi_due_date date;
8157: l_payroll_id pay_payrolls_f.payroll_id%type;
8158: l_eq_pay_plan ghr_pay_plans.pay_plan%type;
8159: l_from_step ghr_pa_requests.to_step_or_rate%type;
8160: l_wgi_due_Date varchar2(60);
8161: l_wgi_pay_date date;