APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_PAYROLL_ACTIONS

Line 132: pay_payroll_actions ppa

128: - (instr(ppa.legislative_parameters,
129: 'END_DATE=')
130: + length('END_DATE='))))))
131: from pay_assignment_actions paa,
132: pay_payroll_actions ppa
133: where paa.tax_unit_id = cp_tax_unit_id
134: and ppa.payroll_action_id=paa.payroll_action_id
135: and ppa.report_type='SS_AFFILIATION'
136: and ppa.report_qualifier ='SALARY'

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

219: ,p_gre_id out nocopy number
220: ,p_event_group_id out nocopy number
221: )
222: IS
223: -- cursor to get all the parameters from pay_payroll_actions table
224:
225: cursor c_payroll_Action_info(cp_payroll_action_id in number) is
226: select business_group_id,
227: to_number(substr(legislative_parameters,

Line 293: from pay_payroll_actions

289: - (instr(legislative_parameters,
290: 'REPORT_MODE=')
291: + length('REPORT_MODE='))))) -- report_mode
292:
293: from pay_payroll_actions
294: where payroll_action_id = cp_payroll_action_id;
295:
296: cursor c_get_imp_date(cp_organization_id in number)
297: is

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

332: hr_utility.set_location(gv_package || lv_procedure_name, 10);
333: ln_step := 1;
334: dbg('Entering get_payroll_action_info .......');
335:
336: -- open the cursor to get all the parameters from pay_payroll_actions table
337: open c_payroll_action_info(p_payroll_action_id);
338: fetch c_payroll_action_info into ln_business_group_id,
339: ln_gre_id,
340: ln_tran_gre_id,

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

466: hr_utility.set_location(gv_package || lv_procedure_name, 10);
467:
468: lv_func_area := 'SS Affiliation Salary Events' ;
469:
470: -- Get all the parameter information from pay_payroll_actions table
471: dbg('Get parameter information from pay_payroll_actions table' ) ;
472:
473: get_payroll_action_info( p_payroll_action_id => p_payroll_action_id
474: ,p_report_mode => lv_report_mode

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

467:
468: lv_func_area := 'SS Affiliation Salary Events' ;
469:
470: -- Get all the parameter information from pay_payroll_actions table
471: dbg('Get parameter information from pay_payroll_actions table' ) ;
472:
473: get_payroll_action_info( p_payroll_action_id => p_payroll_action_id
474: ,p_report_mode => lv_report_mode
475: ,p_period_start_date => ld_period_start_date

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

779: lv_procedure_name := '.action_creation';
780:
781: hr_utility.set_location(gv_package || lv_procedure_name, 10);
782: ln_step := 1;
783: dbg('Get parameter information from pay_payroll_actions table' ) ;
784:
785: get_payroll_action_info( p_payroll_action_id => p_payroll_action_id
786: ,p_report_mode => lv_report_mode
787: ,p_period_start_date => ld_period_start_date

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

1392: dbg('Payroll action id' || to_char(ln_payroll_action_id) );
1393:
1394: hr_utility.set_location(gv_package || lv_procedure_name, 20);
1395: ln_step := 2;
1396: dbg('Get parameter information from pay_payroll_actions table' ) ;
1397: get_payroll_action_info( p_payroll_action_id => ln_payroll_action_id
1398: ,p_report_mode => lv_report_mode
1399: ,p_period_start_date => ld_period_start_date
1400: ,p_period_end_date => ld_period_end_date