DBA Data[Home] [Help]

APPS.PAY_NZ_EDF dependencies on HR_ORGANIZATION_INFORMATION

Line 233: l_er_ird_number hr_organization_information.org_information1%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;
237: l_esct_ded pay_run_result_values.result_value%TYPE;

Line 319: hr_organization_information i,

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,
323: pay_balance_types pbt,