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

Line 1523: pay_payment_types ppt,

1519: ppttl.payment_type_name pay_type,
1520: ppp.value value
1521: FROM pay_org_payment_methods_f pop,
1522: pay_assignment_actions paa,
1523: pay_payment_types ppt,
1524: pay_payment_types_tl ppttl,
1525: pay_pre_payments ppp
1526: WHERE paa.assignment_action_id = p_prepay_assact_id
1527: AND ppt.payment_type_id = pop.payment_type_id

Line 1524: pay_payment_types_tl ppttl,

1520: ppp.value value
1521: FROM pay_org_payment_methods_f pop,
1522: pay_assignment_actions paa,
1523: pay_payment_types ppt,
1524: pay_payment_types_tl ppttl,
1525: pay_pre_payments ppp
1526: WHERE paa.assignment_action_id = p_prepay_assact_id
1527: AND ppt.payment_type_id = pop.payment_type_id
1528: AND ppt.payment_type_id = ppttl.payment_type_id

Line 1552: pay_payment_types ppt,

1548: FROM pay_external_accounts pea,
1549: pay_org_payment_methods_f pop,
1550: pay_personal_payment_methods_f ppm,
1551: pay_assignment_actions paa,
1552: pay_payment_types ppt,
1553: pay_payment_types_tl ppttl,
1554: pay_pre_payments ppp
1555: WHERE pea.id_flex_num=p_flex_num
1556: AND pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)

Line 1553: pay_payment_types_tl ppttl,

1549: pay_org_payment_methods_f pop,
1550: pay_personal_payment_methods_f ppm,
1551: pay_assignment_actions paa,
1552: pay_payment_types ppt,
1553: pay_payment_types_tl ppttl,
1554: pay_pre_payments ppp
1555: WHERE pea.id_flex_num=p_flex_num
1556: AND pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1557: AND paa.assignment_action_id = p_prepay_assact_id