APPS.JA_JAINRECI_XMLP_PKG dependencies on HR_LOCATIONS

Line 113: HR_LOCATIONS

109: BEGIN
110: FOR loc_rec IN (SELECT
111: DESCRIPTION
112: FROM
113: HR_LOCATIONS
114: WHERE LOCATION_ID = cf_3formula.LOCATION_ID) LOOP
115: RETURN LOC_REC.DESCRIPTION;
116: END LOOP;
117: RETURN NULL;

Line 125: HR_LOCATIONS

121: BEGIN
122: FOR loc_rec IN (SELECT
123: COUNTRY
124: FROM
125: HR_LOCATIONS
126: WHERE LOCATION_ID = cf_4formula.LOCATION_ID) LOOP
127: RETURN LOC_REC.COUNTRY;
128: END LOOP;
129: RETURN NULL;

Line 137: HR_LOCATIONS

133: BEGIN
134: FOR loc_rec IN (SELECT
135: ADDRESS_LINE_1
136: FROM
137: HR_LOCATIONS
138: WHERE LOCATION_ID = CF_5FORMULA.LOCATION_ID) LOOP
139: RETURN LOC_REC.ADDRESS_LINE_1;
140: END LOOP;
141: RETURN NULL;

Line 149: HR_LOCATIONS

145: BEGIN
146: FOR loc_rec IN (SELECT
147: ADDRESS_LINE_2
148: FROM
149: HR_LOCATIONS
150: WHERE LOCATION_ID = CF_6FORMULA.LOCATION_ID) LOOP
151: RETURN LOC_REC.ADDRESS_LINE_2;
152: END LOOP;
153: RETURN NULL;

Line 161: HR_LOCATIONS

157: BEGIN
158: FOR loc_rec IN (SELECT
159: ADDRESS_LINE_3
160: FROM
161: HR_LOCATIONS
162: WHERE LOCATION_ID = CF_7FORMULA.LOCATION_ID) LOOP
163: RETURN LOC_REC.ADDRESS_LINE_3;
164: END LOOP;
165: RETURN NULL;