DBA Data[Home] [Help]

APPS.GHG_EMISSION_RATES_PKG dependencies on HR_LOCATIONS

Line 399: from hr_locations hr

395: 'REGION_2', hr.region_3,
396: 'COUNTRY', hr.country, --14119516 (sasuren)
397: 'ALL') STATE
398: into v_location
399: from hr_locations hr
400: , FND_DESCR_FLEX_COL_USAGE_VL fnd
401: WHERE fnd.APPLICATION_ID =800
402: AND fnd.DESCRIPTIVE_FLEXFIELD_NAME='Address Location'
403: AND fnd.DESCRIPTIVE_FLEX_CONTEXT_CODE = hr.style

Line 509: from hr_locations hr

505: 'REGION_2', hr.region_3,
506: 'COUNTRY', hr.country, --14119516 (sasuren)
507: 'ALL') STATE
508: into v_location
509: from hr_locations hr
510: , FND_DESCR_FLEX_COL_USAGE_VL fnd
511: WHERE fnd.APPLICATION_ID =800
512: AND fnd.DESCRIPTIVE_FLEXFIELD_NAME='Address Location'
513: AND fnd.DESCRIPTIVE_FLEX_CONTEXT_CODE = hr.style

Line 742: from hr_locations hr

738: 'REGION_2', hr.region_3,
739: 'COUNTRY', hr.country, --14119516 (sasuren)
740: 'ALL') STATE
741: into v_location
742: from hr_locations hr
743: , FND_DESCR_FLEX_COL_USAGE_VL fnd
744: WHERE fnd.APPLICATION_ID =800
745: AND fnd.DESCRIPTIVE_FLEXFIELD_NAME='Address Location'
746: AND fnd.DESCRIPTIVE_FLEX_CONTEXT_CODE = hr.style