APPS.AHL_MC_RULE_PVT dependencies on FND_LOOKUPS

Line 148: FROM ahl_mc_rule_statements rs, fnd_lookups fnd

144: --
145: CURSOR Check_rule_operator_csr (p_rulestmt_id IN NUMBER) IS
146: SELECT rs.operator, rs.subject_id, rs.object_id,
147: fnd.meaning, rs.object_version_number
148: FROM ahl_mc_rule_statements rs, fnd_lookups fnd
149: WHERE rs.rule_statement_id = p_rulestmt_id
150: AND rs.operator = fnd.lookup_code
151: AND fnd.lookup_type = 'AHL_MC_RULE_ALL_OPERATORS';
152: --

Line 184: FROM ahl_mc_rule_statements rs, fnd_lookups fnd

180: rs.ATTRIBUTE12 ,
181: rs.ATTRIBUTE13 ,
182: rs.ATTRIBUTE14 ,
183: rs.ATTRIBUTE15
184: FROM ahl_mc_rule_statements rs, fnd_lookups fnd
185: WHERE rs.rule_statement_id = p_rulestmt_id
186: AND fnd.lookup_code = decode (rs.negation_flag, 'T', rs.operator||'_NOT', rs.operator)
187: AND fnd.lookup_type = 'AHL_MC_RULE_ALL_OPERATORS';
188: --

Line 191: FROM fnd_lookups

187: AND fnd.lookup_type = 'AHL_MC_RULE_ALL_OPERATORS';
188: --
189: CURSOR get_object_type_csr (p_object_type IN VARCHAR2) IS
190: SELECT meaning
191: FROM fnd_lookups
192: WHERE lookup_code = p_object_type
193: AND lookup_type = 'AHL_MC_RULE_OBJECT_TYPES';
194: --
195: CURSOR get_part_number_csr(p_inv_item_id IN NUMBER) IS

Line 698: FROM FND_LOOKUPS

694: WHERE header.mc_header_id = p_header_id;
695: --
696: CURSOR Check_rule_type_csr (p_type IN VARCHAR2) IS
697: SELECT 'X'
698: FROM FND_LOOKUPS
699: WHERE lookup_code = p_type
700: AND lookup_type = 'AHL_MC_RULE_TYPES';
701: --
702: CURSOR Check_rule_name_csr (p_name IN VARCHAR2, p_mc_header_id IN NUMBER) IS

Line 1003: FROM FND_LOOKUPS

999: WHERE rule_id = p_rule_id;
1000: --
1001: CURSOR Check_rule_type_csr (p_type IN VARCHAR2) IS
1002: SELECT 'X'
1003: FROM FND_LOOKUPS
1004: WHERE lookup_code = p_type
1005: AND lookup_type = 'AHL_MC_RULE_TYPES';
1006: --
1007: CURSOR Check_rule_name_csr (p_name IN VARCHAR2,

Line 1876: FROM AHL_MC_RULES_VL rul, FND_LOOKUPS lookup

1872: rul.attribute12,
1873: rul.attribute13,
1874: rul.attribute14,
1875: rul.attribute15
1876: FROM AHL_MC_RULES_VL rul, FND_LOOKUPS lookup
1877: WHERE rul.rule_type_code = lookup.lookup_code
1878: AND lookup.lookup_type = 'AHL_MC_RULE_TYPES'
1879: AND rul.mc_header_id = p_mc_header_id
1880: AND rul.rule_id IN (