APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 55: pay_payroll_actions table in the

51: 16-Jul-2004 kthirmiy 115.9 Added logic to remove the multiple
52: correction records in the
53: interpret_all_asg_events.
54: Added start_date to get it from the
55: pay_payroll_actions table in the
56: get_payroll_action_info procedure.
57: Added a new function get_start_date
58: to return the archive_start_date
59: from the passed parameter legal employer,

Line 219: pay_payroll_actions ppa

215: - (instr(ppa.legislative_parameters,
216: 'END_DATE=')
217: + length('END_DATE='))))))
218: from pay_assignment_actions paa,
219: pay_payroll_actions ppa
220: where paa.tax_unit_id = cp_tax_unit_id
221: and ppa.payroll_action_id=paa.payroll_action_id
222: and ppa.report_type='SS_AFFILIATION'
223: and ppa.report_qualifier ='IMSS'

Line 292: -- cursor to get all the parameters from pay_payroll_actions table

288: ,p_gre_id out nocopy number
289: ,p_event_group_id out nocopy number
290: )
291: IS
292: -- cursor to get all the parameters from pay_payroll_actions table
293:
294: cursor c_payroll_Action_info(cp_payroll_action_id in number) is
295: select business_group_id,
296: to_number(substr(legislative_parameters,

Line 339: from pay_payroll_actions

335: 'END_DATE=') - 1 )
336: - (instr(legislative_parameters,
337: 'START_DATE=')
338: + length('START_DATE=')))))) -- start_date
339: from pay_payroll_actions
340: where payroll_action_id = cp_payroll_action_id;
341:
342: cursor c_get_imp_date(cp_organization_id in number)
343: is

Line 379: -- open the cursor to get all the parameters from pay_payroll_actions table

375: hr_utility.set_location(gv_package || lv_procedure_name, 10);
376: ln_step := 1;
377: dbg('Entering get_payroll_action_info .......');
378:
379: -- open the cursor to get all the parameters from pay_payroll_actions table
380: open c_payroll_action_info(p_payroll_action_id);
381: fetch c_payroll_action_info into ln_business_group_id,
382: ln_gre_id,
383: ln_tran_gre_id,

Line 498: -- Get all the parameter information from pay_payroll_actions table

494: hr_utility.set_location(gv_package || lv_procedure_name, 10);
495:
496: lv_func_area := 'SS Affiliation Events' ;
497:
498: -- Get all the parameter information from pay_payroll_actions table
499: dbg('Get parameter information from pay_payroll_actions table' ) ;
500:
501: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
502: ,p_start_date => ld_start_date

Line 499: dbg('Get parameter information from pay_payroll_actions table' ) ;

495:
496: lv_func_area := 'SS Affiliation Events' ;
497:
498: -- Get all the parameter information from pay_payroll_actions table
499: dbg('Get parameter information from pay_payroll_actions table' ) ;
500:
501: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
502: ,p_start_date => ld_start_date
503: ,p_end_date => ld_end_date

Line 689: dbg('Get parameter information from pay_payroll_actions table' ) ;

685: lv_procedure_name := '.action_creation';
686:
687: hr_utility.set_location(gv_package || lv_procedure_name, 10);
688: ln_step := 1;
689: dbg('Get parameter information from pay_payroll_actions table' ) ;
690:
691: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
692: ,p_start_date => ld_start_date
693: ,p_end_date => ld_end_date

Line 3188: dbg('Get parameter information from pay_payroll_actions table' ) ;

3184: dbg('Payroll action id' || to_char(ln_payroll_action_id) );
3185:
3186: hr_utility.set_location(gv_package || lv_procedure_name, 20);
3187: ln_step := 2;
3188: dbg('Get parameter information from pay_payroll_actions table' ) ;
3189: get_payroll_action_info(p_payroll_action_id => ln_payroll_action_id
3190: ,p_start_date => ld_start_date
3191: ,p_end_date => ld_end_date
3192: ,p_business_group_id => ln_business_group_id