APPS.PAY_NO_HOLIDAY_PAY dependencies on HR_ORGANIZATION_INFORMATION

Line 130: FROM hr_organization_information hoi

126: --Added Cursor to get the legal employer details
127: CURSOR csr_le_details IS
128: SELECT hoi.org_information1 holiday_entitlement,
129: hoi.org_information2 holiday_pay_calc_basis
130: FROM hr_organization_information hoi
131: WHERE hoi.organization_id = p_tax_unit_id
132: AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
133:
134: CURSOR csr_globals(p_global_name VARCHAR2) IS

Line 329: FROM hr_organization_information hoi

325: hoi.org_information3 holiday_pay_in_fixed_period,
326: hoi.org_information4 hol_pay_over60_in_fix_period,
327: hoi.org_information5 holiday_pay_to_be_adjusted,
328: hoi.org_information6 res_hol_pay_to_6g_for_over60
329: FROM hr_organization_information hoi
330: WHERE hoi.organization_id = p_tax_unit_id
331: AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
332:
333: CURSOR csr_le_hourly_sal IS

Line 335: FROM hr_organization_information hoi

331: AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
332:
333: CURSOR csr_le_hourly_sal IS
334: SELECT hoi.org_information5 hourly_salaried_code
335: FROM hr_organization_information hoi
336: WHERE hoi.organization_id = p_tax_unit_id
337: AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';
338:
339: l_person_details csr_person_details % rowtype;

Line 473: FROM hr_organization_information hoi

469:
470: --Added Cursor to get the legal employer details
471: CURSOR csr_le_details IS
472: SELECT hoi.org_information9 hol_accrual_entit
473: FROM hr_organization_information hoi
474: WHERE hoi.organization_id = p_tax_unit_id
475: AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';
476:
477: l_person_details csr_person_details % rowtype;