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_FI_ARCHIVE_PYSA dependencies on PAY_PAYMENT_TYPES

Line 1254: pay_payment_types ppt,

1250: ppttl.payment_type_name pay_type,
1251: ppp.value value
1252: FROM pay_org_payment_methods_f pop,
1253: pay_assignment_actions paa,
1254: pay_payment_types ppt,
1255: pay_payment_types_tl ppttl,
1256: pay_pre_payments ppp
1257: WHERE paa.assignment_action_id = p_prepay_assact_id
1258: AND ppt.payment_type_id = pop.payment_type_id

Line 1255: pay_payment_types_tl ppttl,

1251: ppp.value value
1252: FROM pay_org_payment_methods_f pop,
1253: pay_assignment_actions paa,
1254: pay_payment_types ppt,
1255: pay_payment_types_tl ppttl,
1256: pay_pre_payments ppp
1257: WHERE paa.assignment_action_id = p_prepay_assact_id
1258: AND ppt.payment_type_id = pop.payment_type_id
1259: AND ppt.payment_type_id = ppttl.payment_type_id

Line 1281: pay_payment_types ppt,

1277: FROM pay_external_accounts pea,
1278: pay_org_payment_methods_f pop,
1279: pay_personal_payment_methods_f ppm,
1280: pay_assignment_actions paa,
1281: pay_payment_types ppt,
1282: pay_payment_types_tl ppttl,
1283: pay_pre_payments ppp
1284: WHERE pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1285: AND paa.assignment_action_id = p_prepay_assact_id

Line 1282: pay_payment_types_tl ppttl,

1278: pay_org_payment_methods_f pop,
1279: pay_personal_payment_methods_f ppm,
1280: pay_assignment_actions paa,
1281: pay_payment_types ppt,
1282: pay_payment_types_tl ppttl,
1283: pay_pre_payments ppp
1284: WHERE pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1285: AND paa.assignment_action_id = p_prepay_assact_id
1286: AND paa.assignment_id = ppm.assignment_id