[Home] [Help]
29: --
30: CURSOR csr_message_info(p_action_context_id NUMBER
31: ,p_category VARCHAR2) IS
32: SELECT pai.*
33: FROM pay_action_information pai
34: WHERE pai.action_context_type = 'PA'
35: AND pai.action_context_id = p_action_context_id
36: AND pai.action_information_category = p_category;
37: --
40: ,p_type VARCHAR2
41: ,p_start_date VARCHAR2
42: ,p_end_date VARCHAR2) IS
43: SELECT pai.*
44: FROM pay_action_information pai
45: WHERE pai.action_context_type = 'PA'
46: AND pai.action_context_id = p_action_context_id
47: AND pai.action_information_category = p_category
48: AND pai.action_information1 = p_type
55: ,p_type VARCHAR2
56: ,p_start_date VARCHAR2
57: ,p_end_date VARCHAR2) IS
58: SELECT pai.*
59: FROM pay_action_information pai
60: WHERE pai.action_context_type = 'PA'
61: AND pai.action_context_id = p_action_context_id
62: AND pai.action_information_category = p_category
63: AND pai.action_information1 = p_type
68: CURSOR csr_corr_balance_info(p_action_context_id NUMBER
69: ,p_category VARCHAR2
70: ,p_type VARCHAR2) IS
71: SELECT pai.*
72: FROM pay_action_information pai
73: WHERE pai.action_context_type = 'PA'
74: AND pai.action_context_id = p_action_context_id
75: AND pai.action_information_category = p_category
76: AND pai.action_information1 = p_type;
120: ,pai.action_information27
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
147: ,p_type VARCHAR2
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
162: ,p_category VARCHAR2
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
176: ,p_category VARCHAR2
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
190: ,p_category VARCHAR2
191: ,p_type VARCHAR2) IS
192: SELECT DISTINCT action_information3
193: ,action_information4
194: FROM pay_action_information pai
195: WHERE pai.action_context_type = 'PA'
196: AND pai.action_context_id = p_action_context_id
197: AND pai.action_information_category = p_category
198: AND pai.action_information1 = p_type; */
201: ,p_category VARCHAR2
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