APPS.PAY_CE_RECONCILIATION_PKG dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 19: l_pay_currency_code pay_org_payment_methods_f.currency_code%type;

15: e_payment_voided exception;
16: e_payment_amount_mismatch exception;
17: e_no_matching_payment exception;
18:
19: l_pay_currency_code pay_org_payment_methods_f.currency_code%type;
20: l_recon_currency_code pay_org_payment_methods_f.currency_code%type;
21: l_value Pay_pre_payments.value%type;
22: l_base_currency_value pay_pre_payments.base_currency_value%type;
23: l_action_status pay_payroll_actions.action_status%type;

Line 20: l_recon_currency_code pay_org_payment_methods_f.currency_code%type;

16: e_payment_amount_mismatch exception;
17: e_no_matching_payment exception;
18:
19: l_pay_currency_code pay_org_payment_methods_f.currency_code%type;
20: l_recon_currency_code pay_org_payment_methods_f.currency_code%type;
21: l_value Pay_pre_payments.value%type;
22: l_base_currency_value pay_pre_payments.base_currency_value%type;
23: l_action_status pay_payroll_actions.action_status%type;
24: l_business_group_id number;

Line 312: l_payment_type_id pay_org_payment_methods_f.payment_type_id%type;

308: p_assignment_action_id number)
309: return varchar2 is
310: --
311: l_effective_date pay_payroll_actions.effective_date%type;
312: l_payment_type_id pay_org_payment_methods_f.payment_type_id%type;
313: l_org_payment_method_id pay_pre_payments.org_payment_method_id%type;
314: l_personal_payment_method_id pay_pre_payments.personal_payment_method_id%type;
315: l_pre_payment_id pay_pre_payments.pre_payment_id%type;
316: l_payroll_action_id pay_assignment_actions.payroll_action_id%type;

Line 337: pay_org_payment_methods_f OP

333: from pay_payroll_actions PA,
334: pay_assignment_actions AA,
335: -- pay_action_interlocks INT,
336: pay_pre_payments PP,
337: pay_org_payment_methods_f OP
338: where PA.payroll_action_id = AA.payroll_action_id
339: and AA.assignment_action_id = p_assignment_action_id
340: -- and AA.assignment_action_id = INT.locking_action_id
341: -- and PP.assignment_action_id = INT.locked_action_id