APPS.OZF_NA_RULE_LINE_PVT dependencies on OZF_NA_DEDUCTION_RULES_TL

Line 48: SELECT name FROM ozf_na_deduction_rules_tl

44: FUNCTION get_ddn_rule_name(pa_na_ddn_rule_id IN NUMBER)
45: RETURN VARCHAR2
46: IS
47: CURSOR c_name(pa_na_ddn_rule_id NUMBER ) IS
48: SELECT name FROM ozf_na_deduction_rules_tl
49: WHERE NA_DEDUCTION_RULE_ID = pa_na_ddn_rule_id
50: AND LANGUAGE = userenv('lang');
51: l_name ozf_na_deduction_rules_tl.name %type;
52:

Line 51: l_name ozf_na_deduction_rules_tl.name %type;

47: CURSOR c_name(pa_na_ddn_rule_id NUMBER ) IS
48: SELECT name FROM ozf_na_deduction_rules_tl
49: WHERE NA_DEDUCTION_RULE_ID = pa_na_ddn_rule_id
50: AND LANGUAGE = userenv('lang');
51: l_name ozf_na_deduction_rules_tl.name %type;
52:
53: BEGIN
54: OPEN c_name(pa_na_ddn_rule_id);
55: fetch c_name into l_name ;