DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_PAYMENT_TYPES_TL

Line 2583: pay_payment_types_tl ppttl,

2579: ppp.value value
2580: FROM pay_org_payment_methods_f pop,
2581: pay_assignment_actions paa,
2582: pay_payment_types ppt,
2583: pay_payment_types_tl ppttl,
2584: pay_pre_payments ppp
2585: WHERE paa.assignment_action_id = p_prepay_assact_id
2586: AND ppt.payment_type_id = pop.payment_type_id
2587: AND ppt.payment_type_id = ppttl.payment_type_id

Line 2614: pay_payment_types_tl ppttl,

2610: pay_org_payment_methods_f pop,
2611: pay_personal_payment_methods_f ppm,
2612: pay_assignment_actions paa,
2613: pay_payment_types ppt,
2614: pay_payment_types_tl ppttl,
2615: pay_pre_payments ppp
2616: WHERE
2617: -- pea.id_flex_num=20 AND
2618: pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)