DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on PAY_PAYMENT_TYPES_TL

Line 1658: pay_payment_types_tl ppttl,

1654: ppp.value value
1655: FROM pay_org_payment_methods_f pop,
1656: pay_assignment_actions paa,
1657: pay_payment_types ppt,
1658: pay_payment_types_tl ppttl,
1659: pay_pre_payments ppp
1660: WHERE paa.assignment_action_id = p_prepay_assact_id
1661: AND ppt.payment_type_id = pop.payment_type_id
1662: AND ppt.payment_type_id = ppttl.payment_type_id

Line 1686: pay_payment_types_tl ppttl,

1682: pay_org_payment_methods_f pop,
1683: pay_personal_payment_methods_f ppm,
1684: pay_assignment_actions paa,
1685: pay_payment_types ppt,
1686: pay_payment_types_tl ppttl,
1687: pay_pre_payments ppp
1688: WHERE pea.id_flex_num=20
1689: AND pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1690: AND paa.assignment_action_id = p_prepay_assact_id