APPS.OZF_NA_RULE_HEADER_PVT dependencies on OZF_NA_RULE_HEADERS_TL

Line 39: SELECT name FROM OZF_NA_RULE_HEADERS_TL

35: FUNCTION get_rule_name(p_na_rule_header_id IN NUMBER)
36: RETURN VARCHAR2
37: IS
38: CURSOR c_rule_name (p_na_rule_header_id NUMBER ) IS
39: SELECT name FROM OZF_NA_RULE_HEADERS_TL
40: WHERE na_rule_header_id = p_na_rule_header_id
41: AND language = userenv('lang');
42:
43: l_name OZF_NA_RULE_HEADERS_TL.name%type;

Line 43: l_name OZF_NA_RULE_HEADERS_TL.name%type;

39: SELECT name FROM OZF_NA_RULE_HEADERS_TL
40: WHERE na_rule_header_id = p_na_rule_header_id
41: AND language = userenv('lang');
42:
43: l_name OZF_NA_RULE_HEADERS_TL.name%type;
44: BEGIN
45: OPEN c_rule_name (p_na_rule_header_id);
46: FETCH c_rule_name INTO l_name;
47: close c_rule_name ;