DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PAY_PAYMENT_TYPES_TL

Line 2572: pay_payment_types_tl ppttl,

2568: ppp.value value
2569: FROM pay_org_payment_methods_f pop,
2570: pay_assignment_actions paa,
2571: pay_payment_types ppt,
2572: pay_payment_types_tl ppttl,
2573: pay_pre_payments ppp
2574: WHERE paa.assignment_action_id = p_prepay_assact_id
2575: AND ppt.payment_type_id = pop.payment_type_id
2576: AND ppt.payment_type_id = ppttl.payment_type_id

Line 2603: pay_payment_types_tl ppttl,

2599: pay_org_payment_methods_f pop,
2600: pay_personal_payment_methods_f ppm,
2601: pay_assignment_actions paa,
2602: pay_payment_types ppt,
2603: pay_payment_types_tl ppttl,
2604: pay_pre_payments ppp
2605: WHERE
2606: -- pea.id_flex_num=20 AND
2607: pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)