DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_ARCHIVE dependencies on PAY_PAYMENT_TYPES_TL

Line 1402: pay_payment_types_tl ppttl,

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

Line 1429: pay_payment_types_tl ppttl,

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