APPS.PAY_CA_ARCHIVE_RULES dependencies on PAY_PAYROLL_ACTIONS

Line 87: from pay_payroll_actions ppa

83:
84: hr_utility.trace('PACTID = '||to_char(pactid));
85: select ppa.legislative_parameters
86: into lv_legislative_param
87: from pay_payroll_actions ppa
88: where payroll_action_id = pactid;
89: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
90: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
91:

Line 139: FROM pay_payroll_actions

135: INTO ld_effective_date,
136: ln_tax_unit_id,
137: l_pre_organization_id,
138: l_report_type
139: FROM pay_payroll_actions
140: WHERE payroll_action_id = pactid;
141:
142: ld_year_start := trunc(ld_effective_date, 'Y');
143: hr_utility.trace('year start new '|| to_char(ld_year_start,'dd-mm-yyyy'));

Line 161: FROM pay_payroll_actions ppa,

157: and PAA.tax_unit_id=hoi.organization_id
158: )';
159: end if;
160: sqlstr := sqlstr ||'AND not exists (SELECT 1
161: FROM pay_payroll_actions ppa,
162: pay_assignment_actions paa
163: WHERE ppa.report_type = ''' || l_report_type ||
164: ''' AND ppa.action_status = ''C''
165: AND ppa.effective_date = '''|| ld_year_end ||'''

Line 221: from pay_payroll_actions ppa

217:
218: hr_utility.trace('PACTID = '||to_char(pactid));
219: select ppa.legislative_parameters
220: into lv_legislative_param
221: from pay_payroll_actions ppa
222: where payroll_action_id = pactid;
223: l_pre_organization_id := pay_core_utils.get_parameter('TRANSFER_PRE',lv_legislative_param);
224: l_gre_id := pay_core_utils.get_parameter('TRANSFER_GRE',lv_legislative_param);
225:

Line 232: FROM pay_payroll_actions

228: SELECT effective_date,
229: pay_core_utils.get_parameter('REPORT_TYPE',legislative_parameters)
230: INTO ld_effective_date,
231: l_report_type
232: FROM pay_payroll_actions
233: WHERE payroll_action_id = pactid;
234:
235: ld_year_start := trunc(ld_effective_date, 'Y');
236: hr_utility.trace('year start new '|| to_char(ld_year_start,'dd-mm-yyyy'));