DBA Data[Home] [Help]

APPS.PAY_AE_ARCHIVE dependencies on PAY_PAYMENT_TYPES_TL

Line 1785: pay_payment_types_tl ppttl,

1781: ppp.value value
1782: FROM pay_org_payment_methods_f pop,
1783: pay_assignment_actions paa,
1784: pay_payment_types ppt,
1785: pay_payment_types_tl ppttl,
1786: pay_pre_payments ppp
1787: WHERE paa.assignment_action_id = p_prepay_assact_id
1788: AND ppt.payment_type_id = pop.payment_type_id
1789: AND ppt.payment_type_id = ppttl.payment_type_id

Line 1813: pay_payment_types_tl ppttl,

1809: pay_org_payment_methods_f pop,
1810: pay_personal_payment_methods_f ppm,
1811: pay_assignment_actions paa,
1812: pay_payment_types ppt,
1813: pay_payment_types_tl ppttl,
1814: pay_pre_payments ppp
1815: WHERE pea.id_flex_num=p_flex_num
1816: AND pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1817: AND paa.assignment_action_id = p_prepay_assact_id