APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_RULES_VL

Line 998: FROM AHL_MC_RULES_VL

994: IS
995: --
996: CURSOR get_rule_rec_csr (p_rule_id IN NUMBER) IS
997: SELECT *
998: FROM AHL_MC_RULES_VL
999: WHERE rule_id = p_rule_id;
1000: --
1001: CURSOR Check_rule_type_csr (p_type IN VARCHAR2) IS
1002: SELECT 'X'

Line 1559: FROM AHL_MC_RULES_VL

1555: IS
1556: --
1557: CURSOR get_rule_rec_csr (p_mc_header_id IN NUMBER) IS
1558: SELECT *
1559: FROM AHL_MC_RULES_VL
1560: WHERE MC_HEADER_ID = p_mc_header_id;
1561: --
1562: CURSOR get_rule_stmt_id_csr (p_rule_id IN NUMBER) IS
1563: SELECT rule_statement_id

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 (