64: pai.action_information27 a27, pai1.action_information27 aa27,
65: pai.action_information28 a28, pai1.action_information28 aa28,
66: pai.action_information29 a29, pai1.action_information29 aa29,
67: pai.action_information30 a30, pai1.action_information30 aa30
68: FROM pay_action_information pai
69: ,pay_action_information pai1
70: ,pay_assignment_actions paa
71: WHERE pai.action_context_type = 'PA'
72: AND pai.action_information_category = p_pa_category
65: pai.action_information28 a28, pai1.action_information28 aa28,
66: pai.action_information29 a29, pai1.action_information29 aa29,
67: pai.action_information30 a30, pai1.action_information30 aa30
68: FROM pay_action_information pai
69: ,pay_action_information pai1
70: ,pay_assignment_actions paa
71: WHERE pai.action_context_type = 'PA'
72: AND pai.action_information_category = p_pa_category
73: AND pai1.action_context_type = 'AAP'