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_PAYMENT_TYPES

Line 370: l_function_name pay_payment_types.reconciliation_function%TYPE;

366: p_assignment_action_id number,
367: p_pre_payment_id number,
368: p_delimiter_string varchar2 default '/') return varchar2 is
369: --
370: l_function_name pay_payment_types.reconciliation_function%TYPE;
371: l_identifier_value varchar2(255);
372: sql_curs number;
373: statem varchar2(2000);
374: rows_processed number;

Line 378: from pay_payment_types pyt

374: rows_processed number;
375: --
376: cursor csr_payment_function is
377: select pyt.reconciliation_function
378: from pay_payment_types pyt
379: where pyt.payment_type_id = p_payment_type_id
380: and pyt.reconciliation_function is not null;
381: --
382: cursor csr_payee_bank_details (p_info_type varchar2) is

Line 388: pay_payment_types ppt,

384: ppm.external_account_id,
385: p_info_type,
386: nvl(ppt.TERRITORY_CODE,pbg.legislation_code))
387: from per_business_groups_perf pbg,
388: pay_payment_types ppt,
389: pay_personal_payment_methods_f ppm
390: where ppm.personal_payment_method_id = p_personal_payment_method_id
391: and p_effective_date between ppm.effective_start_date
392: and ppm.effective_end_date