[Home] [Help]
46: c_non_zero_run_balance and
47: c_non_zero_run_result is handled
48: by ref cursor so that RL1 and
49: RL2 PRE can be handled
50: 06-JAN-2010 aneghosh 115.4 9240092 Added pay_payroll_actions in the
51: join condition in the select query
52: for c_non_zero_run_balance.
53:
54: ******************************************************************************/
79:
80: select ppa.legislative_parameters,
81: ppa.business_group_id
82: into lv_legislative_param, ln_business_group_id
83: from pay_payroll_actions ppa
84: where payroll_action_id = pactid;
85:
86: hr_utility.set_location(l_proc, 20);
87:
106: hr_utility.set_location(l_proc, 60);
107:
108: sqlstr := 'SELECT distinct ASG.person_id
109: FROM per_all_assignments_f ASG,
110: pay_payroll_actions PPA
111: WHERE PPA.payroll_action_id = :payroll_action_id
112: AND ASG.business_group_id = PPA.business_group_id
113: AND ASG.payroll_id is not null
114: AND ASG.assignment_type = ''E''
201: ln_business_group_id,
202: lv_report_type,
203: lv_report_qualifier,
204: lv_report_category
205: FROM pay_payroll_actions
206: WHERE payroll_action_id = pactid;
207:
208:
209: hr_utility.trace('g_effective_date:'|| to_char(g_effective_date,'dd-mm-yyyy'));
263: 'SELECT distinct paf.assignment_id asg_id,
264: paa.assignment_action_id assact
265: FROM per_all_assignments_f paf,
266: pay_assignment_actions paa,
267: pay_payroll_actions ppa,
268: pay_payrolls_f ppf,
269: pay_population_ranges ppr
270: WHERE paf.assignment_id = paa.assignment_id
271: AND paf.assignment_type = ''E''
290: 'SELECT distinct paf.assignment_id asg_id,
291: paa.assignment_action_id assact
292: FROM per_all_assignments_f paf,
293: pay_assignment_actions paa,
294: pay_payroll_actions ppa,
295: pay_payrolls_f ppf
296: WHERE paf.assignment_id = paa.assignment_id
297: AND paf.assignment_type = ''E''
298: AND paf.effective_start_date <= add_months(ppa.effective_date, 12) - 1
407: INTO l_param,
408: l_business_group_id,
409: l_start_date,
410: l_end_date
411: FROM pay_payroll_actions ppa
412: WHERE ppa.payroll_action_id = p_payroll_action_id;
413:
414: l_step := 2;
415: OPEN c_get_leg_code(l_business_group_id);
478: lv_result_value number:=0;
479: lv_count number;
480: l_asgid pay_assignment_actions.assignment_id%TYPE;
481: l_chunk number;
482: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
483: lv_session_id number;
484: l_step number;
485: l_proc VARCHAR2(240);
486: lv_ac_where VARCHAR2(10000);
519: close c_get_session_id;
520:
521: select ppa.business_group_id
522: into ln_business_group_id
523: from pay_payroll_actions ppa
524: where payroll_action_id = l_payroll_action_id;
525:
526: hr_utility.set_location(l_proc, 20);
527:
560: select 1
561: from pay_run_balances prb,
562: pay_balance_attributes pba,
563: pay_assignment_actions paa,
564: pay_payroll_actions ppa
565: where paa.assignment_id = '||to_char(l_asgid)||'
566: AND paa.payroll_action_id = ppa.payroll_action_id
567: AND paa.assignment_Action_id = prb.assignment_Action_id
568: AND prb.effective_date between '''||to_char(add_months(g_effective_date,-12)+1)||
593: FROM pay_run_results prr,
594: pay_run_result_values prrv,
595: pay_input_values_f piv,
596: pay_assignment_actions paa,
597: pay_payroll_actions ppa,
598: pay_payrolls_f ppf
599: WHERE paa.assignment_id = '||to_char(l_asgid)||'
600: AND prr.assignment_Action_id = paa.assignment_Action_id
601: AND ppa.payroll_action_id = paa.payroll_action_id
682: pay_core_utils.get_parameter('TRANSFER_GRE',
683: legislative_parameters)
684: into g_effective_date,
685: g_tax_unit_id
686: from pay_payroll_actions
687: where payroll_action_id = p_payroll_action_id;
688: --
689: hr_utility.trace('g_effective_date ='||g_effective_date);
690: hr_utility.trace('g_tax_unit_id ='||g_tax_unit_id);