APPS.PER_MX_SSAFFL_DISPMAG dependencies on PAY_PAYROLL_ACTIONS

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

107: ,p_gre_id out nocopy number
108: ,p_affl_type out nocopy varchar2
109: )
110: IS
111: -- cursor to get all the parameters from pay_payroll_actions table
112:
113: cursor c_payroll_Action_info(cp_payroll_action_id in number) is
114: select business_group_id,
115: report_qualifier,

Line 129: from pay_payroll_actions

125: 'GRE_ID=') - 1 )
126: - (instr(legislative_parameters,
127: 'TRANS_GRE=')
128: + length('TRANS_GRE='))))))
129: from pay_payroll_actions
130: where payroll_action_id = cp_payroll_action_id;
131:
132:
133: ln_business_group_id NUMBER;

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

146: hr_utility.set_location(gv_package || lv_procedure_name, 10);
147: ln_step := 1;
148: dbg('Entering get_payroll_action_info .......');
149:
150: -- open the cursor to get all the parameters from pay_payroll_actions table
151: open c_payroll_action_info(p_payroll_action_id);
152: fetch c_payroll_action_info into ln_business_group_id,
153: lv_affl_type,
154: ln_gre_id,

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

215:
216: lv_procedure_name := '.range_cursor';
217: hr_utility.set_location(gv_package || lv_procedure_name, 10);
218:
219: -- Get all the parameter information from pay_payroll_actions table
220: dbg('Get parameter information from pay_payroll_actions table' ) ;
221:
222: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
223: ,p_business_group_id => ln_business_group_id

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

216: lv_procedure_name := '.range_cursor';
217: hr_utility.set_location(gv_package || lv_procedure_name, 10);
218:
219: -- Get all the parameter information from pay_payroll_actions table
220: dbg('Get parameter information from pay_payroll_actions table' ) ;
221:
222: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
223: ,p_business_group_id => ln_business_group_id
224: ,p_trans_gre_id => ln_trans_gre_id

Line 286: pay_payroll_actions ppa

282: and not exists (
283: select 'Y'
284: from pay_action_interlocks pal,
285: pay_assignment_actions paa,
286: pay_payroll_actions ppa
287: where pal.locked_action_id = pai.action_context_id
288: and pal.locking_action_id = paa.assignment_action_id
289: and paa.payroll_action_id = ppa.payroll_action_id
290: and ppa.action_type='X'

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

318: lv_procedure_name := '.action_creation';
319:
320: hr_utility.set_location(gv_package || lv_procedure_name, 10);
321: ln_step := 1;
322: dbg('Get parameter information from pay_payroll_actions table' ) ;
323:
324: get_payroll_action_info(p_payroll_action_id => p_payroll_action_id
325: ,p_business_group_id => ln_business_group_id
326: ,p_trans_gre_id => ln_trans_gre_id