APPS.PO_POAPPROVAL_INIT1 dependencies on HR_LOCATIONS

Line 1135: -- Given a location ID, concatenates fields from the hr_locations into an

1131: -- None.
1132: --Locks:
1133: -- None.
1134: --Function:
1135: -- Given a location ID, concatenates fields from the hr_locations into an
1136: -- address using different fields and formats for different countries and
1137: -- address types.
1138: --Parameters:
1139: --IN:

Line 1152: --SQL What: Concatenate fields from hr_locations

1148:
1149: l_address varchar2(2000);
1150:
1151: begin
1152: --SQL What: Concatenate fields from hr_locations
1153: --SQL Why: To return an address
1154: SELECT substrb ( part1 || decode(part2, NULL, '', part2 || ' ') || part3,
1155: 1, 2000)
1156: INTO l_address

Line 1177: FROM hr_locations hrl,

1173: AS part2,
1174: decode(hrl.postal_code, null, '', hrl.postal_code || ', ')
1175: || ftv.territory_short_name
1176: AS part3
1177: FROM hr_locations hrl,
1178: fnd_territories_vl ftv,
1179: fnd_lookup_values_vl flv1,
1180: fnd_lookup_values_vl flv2,
1181: fnd_lookup_values_vl flv3