APPS.PAY_CE_RECONCILIATION_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 23: l_action_status pay_payroll_actions.action_status%type;

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;
25:
26: begin
27:

Line 311: l_effective_date pay_payroll_actions.effective_date%type;

307: function payinfo(p_identifier varchar2,
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;

Line 333: from pay_payroll_actions PA,

329: l_org_payment_method_id,
330: l_personal_payment_method_id,
331: l_pre_payment_id,
332: l_payroll_action_id
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