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

Line 1549: pay_payment_types ppt,

1545: ppttl.payment_type_name pay_type,
1546: ppp.value value
1547: FROM pay_org_payment_methods_f pop,
1548: pay_assignment_actions paa,
1549: pay_payment_types ppt,
1550: pay_payment_types_tl ppttl,
1551: pay_pre_payments ppp
1552: WHERE paa.assignment_action_id = p_prepay_assact_id
1553: AND ppt.payment_type_id = pop.payment_type_id

Line 1550: pay_payment_types_tl ppttl,

1546: ppp.value value
1547: FROM pay_org_payment_methods_f pop,
1548: pay_assignment_actions paa,
1549: pay_payment_types ppt,
1550: pay_payment_types_tl ppttl,
1551: pay_pre_payments ppp
1552: WHERE paa.assignment_action_id = p_prepay_assact_id
1553: AND ppt.payment_type_id = pop.payment_type_id
1554: AND ppt.payment_type_id = ppttl.payment_type_id

Line 1577: pay_payment_types ppt,

1573: FROM pay_external_accounts pea,
1574: pay_org_payment_methods_f pop,
1575: pay_personal_payment_methods_f ppm,
1576: pay_assignment_actions paa,
1577: pay_payment_types ppt,
1578: pay_payment_types_tl ppttl,
1579: pay_pre_payments ppp
1580: WHERE pea.id_flex_num=20
1581: AND pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)

Line 1578: pay_payment_types_tl ppttl,

1574: pay_org_payment_methods_f pop,
1575: pay_personal_payment_methods_f ppm,
1576: pay_assignment_actions paa,
1577: pay_payment_types ppt,
1578: pay_payment_types_tl ppttl,
1579: pay_pre_payments ppp
1580: WHERE pea.id_flex_num=20
1581: AND pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1582: AND paa.assignment_action_id = p_prepay_assact_id