50: hr_utility.trace('PACTID = '||to_char(pactid));
51: hr_utility.trace('PACTID = '||to_char(pactid));
52: select ppa.legislative_parameters
53: into lv_legislative_param
54: from pay_payroll_actions ppa
55: where payroll_action_id = pactid;
56: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
57: sqlstr := 'AND PAA.tax_unit_id = '||to_number(l_gre_id);
58:
84: SELECT effective_date,
85: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
86: INTO ld_effective_date,
87: ln_tax_unit_id
88: FROM pay_payroll_actions
89: WHERE payroll_action_id = pactid;
90:
91: ld_year_end := add_months(trunc(ld_effective_date, 'Y'),12) -1;
92: hr_utility.trace('year end '|| to_char(ld_year_end,'dd-mm-yyyy'));
91: ld_year_end := add_months(trunc(ld_effective_date, 'Y'),12) -1;
92: hr_utility.trace('year end '|| to_char(ld_year_end,'dd-mm-yyyy'));
93: sqlstr := ' AND PAA.tax_unit_id = '||to_number(ln_tax_unit_id);
94: sqlstr := sqlstr ||' AND not exists (SELECT 1
95: FROM pay_payroll_actions ppa,
96: pay_assignment_actions paa
97: WHERE ppa.report_type = ''YREND''
98: AND ppa.action_status = ''C''
99: AND ppa.effective_date = '''|| ld_year_end ||'''
126: hr_utility.trace('PACTID = '||to_char(pactid));
127:
128: select ppa.legislative_parameters
129: into lv_legislative_param
130: from pay_payroll_actions ppa
131: where payroll_action_id = pactid;
132:
133: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
134: sqlstr := 'AND PAA.tax_unit_id = '||to_number(l_gre_id);