APPS.PAY_IP_RULES dependencies on PAY_PAYROLLS_F

Line 243: FROM pay_payrolls_f

239: AND ppf.effective_end_date;
240:
241: CURSOR c_get_payroll_name(p_payroll_id number) IS
242: SELECT payroll_name
243: FROM pay_payrolls_f
244: where payroll_id = p_payroll_id;
245:
246: CURSOR c_get_userdefined_proc(cp_business_group_id IN NUMBER,
247: cp_legislation_code IN VARCHAR2) is

Line 287: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;

283: lv_last_name per_people_f.last_name%TYPE;
284: lv_middle_names per_people_f.middle_names%TYPE;
285: lv_order_name per_people_f.order_name%TYPE;
286: lv_full_name per_people_f.full_name%TYPE;
287: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;
288: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
289: ln_per_pay_method number;
290: lv_account_type varchar2(2);
291: l_org_payment_method_id

Line 288: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;

284: lv_middle_names per_people_f.middle_names%TYPE;
285: lv_order_name per_people_f.order_name%TYPE;
286: lv_full_name per_people_f.full_name%TYPE;
287: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;
288: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
289: ln_per_pay_method number;
290: lv_account_type varchar2(2);
291: l_org_payment_method_id
292: pay_personal_payment_methods_f.org_payment_method_id%TYPE;