APPS.PAY_NZ_EDF dependencies on HR_ORGANIZATION_UNITS

Line 232: l_er_name hr_organization_units.name%TYPE;

228: l_addr3 per_addresses.address_line3%TYPE;
229: l_country per_addresses.country%TYPE;
230: l_city per_addresses.town_or_city%TYPE;
231: l_postal_code per_addresses.postal_code%TYPE;
232: l_er_name hr_organization_units.name%TYPE;
233: l_er_ird_number hr_organization_information.org_information1%TYPE;
234: l_paye_ded pay_run_result_values.result_value%TYPE;
235: l_child_support_ded pay_run_result_values.result_value%TYPE;
236: l_student_loan_ded pay_run_result_values.result_value%TYPE;

Line 245: l_tax_unit_id hr_organization_units.organization_id%TYPE;

241: l_period_end_date DATE;
242: l_prd_end_date DATE;
243: l_registered_employer varchar2(100);
244: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
245: l_tax_unit_id hr_organization_units.organization_id%TYPE;
246: l_effective_start_date VARCHAR2(20);
247: l_effective_end_date VARCHAR2(20);
248: l_leg_param pay_payroll_actions.legislative_parameters%TYPE ;
249: l_prd_end_date_ch VARCHAR2(20);

Line 265: CURSOR get_registered_employer(c_business_group_id hr_organization_units.business_group_id%TYPE,

261: pay_core_utils.get_parameter('END_DATE',ppa.legislative_parameters)
262: FROM pay_payroll_actions ppa
263: WHERE ppa.payroll_action_id = c_payroll_action_id;
264:
265: CURSOR get_registered_employer(c_business_group_id hr_organization_units.business_group_id%TYPE,
266: c_registered_employer_id hr_organization_units.organization_id%TYPE)
267: IS
268: SELECT name
269: FROM hr_nz_tax_unit_v

Line 266: c_registered_employer_id hr_organization_units.organization_id%TYPE)

262: FROM pay_payroll_actions ppa
263: WHERE ppa.payroll_action_id = c_payroll_action_id;
264:
265: CURSOR get_registered_employer(c_business_group_id hr_organization_units.business_group_id%TYPE,
266: c_registered_employer_id hr_organization_units.organization_id%TYPE)
267: IS
268: SELECT name
269: FROM hr_nz_tax_unit_v
270: WHERE business_group_id = c_business_group_id

Line 273: CURSOR get_business_group(c_business_group_id hr_organization_units.business_group_id%TYPE)

269: FROM hr_nz_tax_unit_v
270: WHERE business_group_id = c_business_group_id
271: AND tax_unit_id = c_registered_employer_id;
272:
273: CURSOR get_business_group(c_business_group_id hr_organization_units.business_group_id%TYPE)
274: IS
275: SELECT name
276: FROM per_business_groups
277: WHERE business_group_id = c_business_group_id

Line 291: CURSOR csr_edf_record(c_business_group_id IN hr_organization_units.business_group_id%TYPE,

287:
288: /* 9666103 - Removed per_time_periods join and added pact join to fetch the
289: employees processed based on pact.effective_date */
290:
291: CURSOR csr_edf_record(c_business_group_id IN hr_organization_units.business_group_id%TYPE,
292: c_registered_employer_id IN hr_organization_units.organization_id%TYPE,
293: c_period_start_date IN DATE,
294: c_period_end_date IN DATE)
295: IS

Line 292: c_registered_employer_id IN hr_organization_units.organization_id%TYPE,

288: /* 9666103 - Removed per_time_periods join and added pact join to fetch the
289: employees processed based on pact.effective_date */
290:
291: CURSOR csr_edf_record(c_business_group_id IN hr_organization_units.business_group_id%TYPE,
292: c_registered_employer_id IN hr_organization_units.organization_id%TYPE,
293: c_period_start_date IN DATE,
294: c_period_end_date IN DATE)
295: IS
296: SELECT

Line 318: hr_organization_units o,

314: SUM(decode(pbt.balance_name,'SSCWT Deductions' ,target.result_value * feed.scale,0)) sscwt_deductions,
315: SUM(decode(pbt.balance_name,'KiwiSaver Employee Contributions',target.result_value * feed.scale,0)) kiwisaver_employee_deductions,
316: SUM(decode(pbt.balance_name,'KiwiSaver Employer Contributions',target.result_value * feed.scale,0)) kiwisaver_employer_deductions
317: FROM
318: hr_organization_units o,
319: hr_organization_information i,
320: hr_locations l,
321: hr_soft_coding_keyflex scl,
322: per_assignments_f asg,