[Home] [Help]
121: ,pai.action_information28
122: ,pai.action_information29
123: ,pai.action_information30
124: FROM pay_action_information pai
125: ,pay_assignment_actions paa
126: WHERE pai.action_context_type = 'AAP'
127: AND pai.action_context_id = paa.assignment_action_id
128: AND paa.payroll_action_id = p_action_context_id
129: AND pai.action_information_category = p_category
148: ,p_action_information_id NUMBER
149: ,p_assignment_id NUMBER) IS
150: SELECT pai.*
151: FROM pay_action_information pai
152: ,pay_assignment_actions paa
153: WHERE pai.action_context_type = 'AAP'
154: AND pai.action_context_id = paa.assignment_action_id
155: AND paa.payroll_action_id = p_action_context_id
156: AND pai.action_information_category = p_category
163: ,p_type VARCHAR2
164: ,p_action_information_id NUMBER) IS
165: SELECT pai.*
166: FROM pay_action_information pai
167: ,pay_assignment_actions paa
168: WHERE pai.action_context_type = 'AAP'
169: AND pai.action_context_id = paa.assignment_action_id
170: AND paa.payroll_action_id = p_action_context_id
171: AND pai.action_information_category = p_category
177: ,p_type VARCHAR2
178: ,p_action_information_id NUMBER) IS
179: SELECT pai.*
180: FROM pay_action_information pai
181: ,pay_assignment_actions paa
182: WHERE pai.action_context_type = 'AAP'
183: AND pai.action_context_id = paa.assignment_action_id
184: AND paa.payroll_action_id = p_action_context_id
185: AND pai.action_information_category = p_category
202: ,p_type VARCHAR2) IS
203: SELECT DISTINCT action_information2 start_date
204: ,action_information3 end_date
205: FROM pay_action_information pai
206: ,pay_assignment_actions paa
207: WHERE pai.action_context_type = 'AAP'
208: AND pai.action_information_category = p_category
209: AND pai.action_context_id = paa.assignment_action_id
210: AND paa.payroll_action_id = p_action_context_id