APPS.PAY_MX_RULES dependencies on PAY_PAYROLLS_F

Line 609: FROM pay_payrolls_f

605: AND ppf.effective_end_date;
606:
607: CURSOR c_get_payroll_name(p_payroll_id number) IS
608: SELECT payroll_name
609: FROM pay_payrolls_f
610: where payroll_id = p_payroll_id;
611:
612:
613: CURSOR get_account_type(p_per_pay_method NUMBER,

Line 651: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;

647: lv_last_name per_people_f.last_name%TYPE;
648: lv_middle_names per_people_f.middle_names%TYPE;
649: lv_order_name per_people_f.order_name%TYPE;
650: lv_full_name per_people_f.full_name%TYPE;
651: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;
652: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
653: ln_per_pay_method number;
654: lv_account_type varchar2(2);
655: l_org_payment_method_id

Line 652: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;

648: lv_middle_names per_people_f.middle_names%TYPE;
649: lv_order_name per_people_f.order_name%TYPE;
650: lv_full_name per_people_f.full_name%TYPE;
651: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;
652: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
653: ln_per_pay_method number;
654: lv_account_type varchar2(2);
655: l_org_payment_method_id
656: pay_personal_payment_methods_f.org_payment_method_id%TYPE;