APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_HEADERS_V

Line 693: FROM ahl_mc_headers_v header

689: IS
690: --
691: CURSOR check_mc_status_csr (p_header_id IN NUMBER) IS
692: SELECT config_status_code, config_status_meaning
693: FROM ahl_mc_headers_v header
694: WHERE header.mc_header_id = p_header_id;
695: --
696: CURSOR Check_rule_type_csr (p_type IN VARCHAR2) IS
697: SELECT 'X'

Line 1024: FROM ahl_mc_rules_b rule, ahl_mc_headers_v header

1020: WHERE rule_id = p_rule_id;
1021: --
1022: CURSOR check_mc_status_csr (p_rule_id IN NUMBER) IS
1023: SELECT config_status_code, config_status_meaning
1024: FROM ahl_mc_rules_b rule, ahl_mc_headers_v header
1025: WHERE rule.mc_header_id = header.mc_header_id
1026: AND rule.rule_id = p_rule_id;
1027: --
1028: l_api_version CONSTANT NUMBER := 1.0;

Line 1414: FROM ahl_mc_rules_b rule, ahl_mc_headers_v header

1410: AND rule.rule_id = p_rule_id;
1411: --
1412: CURSOR check_mc_status_csr (p_rule_id IN NUMBER) IS
1413: SELECT config_status_code, config_status_meaning, header.mc_header_id
1414: FROM ahl_mc_rules_b rule, ahl_mc_headers_v header
1415: WHERE rule.mc_header_id = header.mc_header_id
1416: AND rule.rule_id = p_rule_id;
1417: --
1418: l_api_version CONSTANT NUMBER := 1.0;