APPS.JAI_ETCS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2636: FROM hr_all_organization_units

2632: jrorv.ORGANIZATION_ID = hrou.org_information3 AND
2633: jrorv.REGIME_CODE = jai_constants.tds_regime ;
2634: /*
2635: SELECT attribute2
2636: FROM hr_all_organization_units
2637: WHERE organization_id = p_organization_id;*/
2638: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 begin
2639: --Commented by Chong for DTC ER 2012/09/11 Get TCS calendar from regime start
2640: /*

Line 2653: FROM hr_all_organization_units

2649: -- code ported from BL12.1.3 by zhiwei.xin on 15-MAR-2013 end.
2650: -- gives Location_id linked to Organization
2651: CURSOR c_location_linked_to_org(p_organization_id IN NUMBER) IS
2652: SELECT location_id
2653: FROM hr_all_organization_units
2654: WHERE organization_id = p_organization_id;
2655:
2656: v_location_id hr_all_organization_units.location_id%TYPE ;
2657:

Line 2656: v_location_id hr_all_organization_units.location_id%TYPE ;

2652: SELECT location_id
2653: FROM hr_all_organization_units
2654: WHERE organization_id = p_organization_id;
2655:
2656: v_location_id hr_all_organization_units.location_id%TYPE ;
2657:
2658: -- to get address details of location linked to given organization
2659: CURSOR c_address_details(p_location_id IN NUMBER) IS
2660: SELECT location_code, address_line_1, address_line_2, address_line_3, null, null,