DBA Data[Home] [Help]

APPS.PAY_US_RULES dependencies on PAY_ACTION_INFORMATION

Line 2466: FROM pay_action_information pai,

2462: SELECT pai.action_information16, ppt.CATEGORY, pai.action_information5,
2463: pai.action_information6, pai.action_information7,
2464: pai.action_information8, pai.action_information9,
2465: pai.action_information10, paa.serial_number
2466: FROM pay_action_information pai,
2467: pay_org_payment_methods_f popmf,
2468: pay_payment_types ppt,
2469: pay_assignment_actions paa
2470: WHERE pai.action_context_id = arch_assact_id

Line 2492: FROM pay_action_information pai,

2488: ),
2489: pai.action_information7, pai.action_information8,
2490: pai.action_information9, pai.action_information10,
2491: pai.action_information17, pai.action_information16
2492: FROM pay_action_information pai,
2493: pay_org_payment_methods_f popmf,
2494: pay_payment_types ppt
2495: WHERE pai.action_information_category = 'EMPLOYEE NET PAY DISTRIBUTION'
2496: AND pai.action_context_id = arch_assact_id

Line 2514: pay_action_information pain

2510: FROM pay_action_interlocks pai,
2511: pay_assignment_actions paa,
2512: pay_payroll_actions ppa,
2513: pay_action_interlocks pai1,
2514: pay_action_information pain
2515: WHERE pai.locking_action_id = cp_assignment_action_id
2516: AND pai.locked_action_id = pai1.locked_action_id
2517: AND pai.locking_action_id <> pai1.locking_action_id
2518: AND pai1.locking_action_id = paa.assignment_action_id