84: WHERE paa1.source_action_id = p_action_context_id
85: AND paa1.action_status = 'C'
86: UNION
87: SELECT p_action_context_id 88: FROM dual ) 89: ORDER BY pai.action_information5,pai1.action_information5 DESC;
90:
91: PROCEDURE get_main_tax_unit_id
92: (p_assignment_id IN NUMBER