APPS.JAI_ETCS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2180: FROM hr_all_organization_units

2176: jrorv.ORGANIZATION_ID = hrou.org_information3 AND
2177: jrorv.REGIME_CODE = jai_constants.tds_regime ;
2178: /*
2179: SELECT attribute2
2180: FROM hr_all_organization_units
2181: WHERE organization_id = p_organization_id;*/
2182:
2183: -- to get financial and assessment years
2184: CURSOR c_fin_year(p_tan_number IN varchar2, p_fin_year IN NUMBER) IS

Line 2193: FROM hr_all_organization_units

2189:
2190: -- gives Location_id linked to Organization
2191: CURSOR c_location_linked_to_org(p_organization_id IN NUMBER) IS
2192: SELECT location_id
2193: FROM hr_all_organization_units
2194: WHERE organization_id = p_organization_id;
2195:
2196: v_location_id hr_all_organization_units.location_id%TYPE ;
2197:

Line 2196: v_location_id hr_all_organization_units.location_id%TYPE ;

2192: SELECT location_id
2193: FROM hr_all_organization_units
2194: WHERE organization_id = p_organization_id;
2195:
2196: v_location_id hr_all_organization_units.location_id%TYPE ;
2197:
2198: -- to get address details of location linked to given organization
2199: CURSOR c_address_details(p_location_id IN NUMBER) IS
2200: SELECT location_code, address_line_1, address_line_2, address_line_3, null, null,