APPS.PAY_NO_HOLIDAY_PAY dependencies on HR_ORGANIZATION_INFORMATION

Line 131: FROM hr_organization_information hoi

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

Line 330: FROM hr_organization_information hoi

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

Line 336: FROM hr_organization_information hoi

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

Line 474: FROM hr_organization_information hoi

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