APPS.PAY_US_ARCHIVE_RULES dependencies on PAY_CORE_UTILS

Line 56: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);

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:
59: hr_utility.set_location(l_proc, 20);
60: hr_utility.trace(sqlstr);

Line 85: pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters)

81:
82: hr_utility.trace('PACTID = '||to_char(pactid));
83:
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;

Line 100: AND pay_core_utils.get_parameter(

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 ||'''
100: AND pay_core_utils.get_parameter(
101: ''TRANSFER_GRE'',
102: legislative_parameters) = '|| ln_tax_unit_id ||'
103: AND ppa.payroll_action_id = paa.payroll_action_id
104: AND paa.action_status = ''C''

Line 133: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);

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);
135: hr_utility.set_location(l_proc, 20);
136: hr_utility.trace(sqlstr);
137: