DBA Data[Home] [Help]

APPS.OKC_AR_INT_PUB dependencies on FND_LOOKUPS

Line 36: FROM fnd_lookups

32:
33: -- list of Rules in seeded Rule Group
34: CURSOR csr_seeded_rules IS
35: SELECT lookup_code
36: FROM fnd_lookups
37: WHERE lookup_type = 'OKC_CONTINGENCY_RULES';
38:
39: -- rule at line level
40: CURSOR csr_line_rules(p_rule_code IN VARCHAR2, p_cle_id IN NUMBER, p_chr_id IN NUMBER) IS

Line 63: l_rule_code fnd_lookups.lookup_code%TYPE;

59: AND rgb.chr_id = p_chr_id
60: AND rul.rule_information_category = p_rule_code;
61:
62:
63: l_rule_code fnd_lookups.lookup_code%TYPE;
64: l_rule_information1 okc_rules_b.rule_information1%TYPE;
65: l_rule_information2 okc_rules_b.rule_information2%TYPE;
66: l_rule_information3 okc_rules_b.rule_information3%TYPE;
67: l_rule_information4 okc_rules_b.rule_information4%TYPE;