APPS.PAY_MX_RULES dependencies on PAY_PAYROLLS_F

Line 590: FROM pay_payrolls_f

586: AND ppf.effective_end_date;
587:
588: CURSOR c_get_payroll_name(p_payroll_id number) IS
589: SELECT payroll_name
590: FROM pay_payrolls_f
591: where payroll_id = p_payroll_id;
592:
593:
594: CURSOR get_account_type(p_per_pay_method NUMBER,

Line 632: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;

628: lv_last_name per_people_f.last_name%TYPE;
629: lv_middle_names per_people_f.middle_names%TYPE;
630: lv_order_name per_people_f.order_name%TYPE;
631: lv_full_name per_people_f.full_name%TYPE;
632: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;
633: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
634: ln_per_pay_method number;
635: lv_account_type varchar2(2);
636: l_org_payment_method_id

Line 633: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;

629: lv_middle_names per_people_f.middle_names%TYPE;
630: lv_order_name per_people_f.order_name%TYPE;
631: lv_full_name per_people_f.full_name%TYPE;
632: lv_payroll_id pay_payrolls_f.payroll_id%TYPE;
633: lv_payroll_name pay_payrolls_f.payroll_name%TYPE;
634: ln_per_pay_method number;
635: lv_account_type varchar2(2);
636: l_org_payment_method_id
637: pay_personal_payment_methods_f.org_payment_method_id%TYPE;