APPS.HR_JP_GENERAL_PKG dependencies on PER_JP_ADDRESS_LOOKUPS

Line 55: l_district_name PER_JP_ADDRESS_LOOKUPS.ADDRESS_LINE_1%TYPE;

51: --------------------------------------------------------------
52: P_DISTRICT_CODE IN VARCHAR2)
53: RETURN VARCHAR2
54: IS
55: l_district_name PER_JP_ADDRESS_LOOKUPS.ADDRESS_LINE_1%TYPE;
56: CURSOR cur_district_name IS
57: select address_line_1
58: from per_jp_address_lookups
59: where district_code=p_district_code;

Line 58: from per_jp_address_lookups

54: IS
55: l_district_name PER_JP_ADDRESS_LOOKUPS.ADDRESS_LINE_1%TYPE;
56: CURSOR cur_district_name IS
57: select address_line_1
58: from per_jp_address_lookups
59: where district_code=p_district_code;
60: BEGIN
61: open cur_district_name;
62: fetch cur_district_name into l_district_name;