DBA Data[Home] [Help]

APPS.PAY_IN_INDIA_BENEFITS dependencies on HR_ORGANIZATION_UNITS

Line 1165: hr_organization_units unit

1161: is
1162: CURSOR csr_element_ids IS
1163: SELECT DECODE(p_element_flag,'MEDBILL',org.org_information1,'MEDPAY',org.org_information2,'LTC_ELE',org.org_information3)
1164: FROM hr_organization_information org,
1165: hr_organization_units unit
1166: WHERE org.org_information_context = 'PER_IN_REIMBURSE_ELEMENTS'
1167: AND org.organization_id =unit.organization_id
1168: AND unit.business_group_id = p_business_group_id;
1169: