APPS.PER_MX_SSAFFL_EXTRACT_PKG dependencies on PAY_ACTION_INFORMATION

Line 147: ** pay_action_information table

143:
144:
145: /************************************************************
146: ** Cursor to get the hire/rehire affiliation records from
147: ** pay_action_information table
148: ************************************************************/
149: cursor c_hire_details( cp_tax_unit_id in number
150: ) is
151: select formated_data_string(action_information1)||

Line 172: from pay_action_information

168: formated_data_string(action_information18) ||
169: formated_data_string(' ') ||
170: formated_data_string(action_information20) ||
171: formated_data_string(action_information21)
172: from pay_action_information
173: where tax_unit_id = cp_tax_unit_id
174: and action_context_type ='AAP'
175: and action_information_category = 'MX SS HIRE DETAILS'
176: and action_information22 ='A' ;

Line 182: ** pay_action_information table

178:
179:
180: /************************************************************
181: ** Cursor to get the HIRE/reHIRE affiliation records from
182: ** pay_action_information table
183: ************************************************************/
184: cursor c_sep_details( cp_tax_unit_id in number
185: ) is
186: select

Line 203: from pay_action_information

199: formated_data_string(action_information13) ||
200: formated_data_string(action_information14) ||
201: formated_data_string(' ') ||
202: formated_data_string(action_information16)
203: from pay_action_information
204: where tax_unit_id = cp_tax_unit_id
205: and action_context_type ='AAP'
206: and action_information_category = 'MX SS SEPARATION DETAILS'
207: and action_information22 ='A' ;

Line 267: update pay_action_information

263: end loop ;
264: close c_HIRE_details ;
265:
266:
267: update pay_action_information
268: set action_information22='M',
269: action_information23='Reported in the IMSS Mag Tape'
270: where tax_unit_id = p_tax_unit_id
271: and action_context_type ='AAP'

Line 293: update pay_action_information

289: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
290: end loop ;
291: close c_sep_details ;
292:
293: update pay_action_information
294: set action_information22='M',
295: action_information23='Reported in the IMSS Mag Tape'
296: where tax_unit_id = p_tax_unit_id
297: and action_context_type ='AAP'