DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_PAYMENT_TYPES_TL

Line 1400: pay_payment_types_tl ppttl,

1396: ppp.value value
1397: FROM pay_org_payment_methods_f pop,
1398: pay_assignment_actions paa,
1399: pay_payment_types ppt,
1400: pay_payment_types_tl ppttl,
1401: pay_pre_payments ppp
1402: WHERE paa.assignment_action_id = p_prepay_assact_id
1403: AND ppt.payment_type_id = pop.payment_type_id
1404: AND ppt.payment_type_id = ppttl.payment_type_id

Line 1427: pay_payment_types_tl ppttl,

1423: pay_org_payment_methods_f pop,
1424: pay_personal_payment_methods_f ppm,
1425: pay_assignment_actions paa,
1426: pay_payment_types ppt,
1427: pay_payment_types_tl ppttl,
1428: pay_pre_payments ppp
1429: WHERE pea.external_account_id = NVL(ppm.external_account_id,pop.external_account_id)
1430: AND paa.assignment_action_id = p_prepay_assact_id
1431: AND paa.assignment_id = ppm.assignment_id