eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CE_RECONCILIATION_PKG dependencies on PAY_PRE_PAYMENTS

Line 21: l_value Pay_pre_payments.value%type;

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;
25:

Line 22: l_base_currency_value pay_pre_payments.base_currency_value%type;

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

Line 313: l_org_payment_method_id pay_pre_payments.org_payment_method_id%type;

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;
317: l_identifier_value varchar2(255);

Line 314: l_personal_payment_method_id pay_pre_payments.personal_payment_method_id%type;

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;
317: l_identifier_value varchar2(255);
318: --

Line 315: l_pre_payment_id pay_pre_payments.pre_payment_id%type;

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;
317: l_identifier_value varchar2(255);
318: --
319: begin

Line 336: pay_pre_payments PP,

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
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