DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_PAYMENT_TYPES

Line 2528: pay_payment_types ppt,

2524: pai.action_information8, pai.action_information9,
2525: pai.action_information10, paa.serial_number
2526: FROM pay_action_information pai,
2527: pay_org_payment_methods_f popmf,
2528: pay_payment_types ppt,
2529: pay_assignment_actions paa
2530: WHERE pai.action_context_id = arch_assact_id
2531: AND pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
2532: AND paa.assignment_action_id = chk_assact_id

Line 2556: pay_payment_types ppt

2552: pai.action_information2, --pai.action_information1 #12549430
2553: ppt.CATEGORY --For bug#9541448
2554: FROM pay_action_information pai,
2555: pay_org_payment_methods_f popmf,
2556: pay_payment_types ppt
2557: WHERE pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
2558: AND pai.action_context_id = arch_assact_id
2559: AND pai.action_information1 = popmf.org_payment_method_id
2560: AND popmf.payment_type_id = ppt.payment_type_id