APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_HEADERS_B

Line 206: FROM ahl_mc_headers_b

202: FROM DUAL;
203: --
204: CURSOR get_mc_name_csr (p_mc_id IN NUMBER) IS
205: SELECT distinct name
206: FROM ahl_mc_headers_b
207: WHERE mc_id = p_mc_id;
208: --
209: l_operator AHL_MC_RULE_STATEMENTS.OPERATOR%TYPE;
210: l_obj_ver_num NUMBER;

Line 928: UPDATE ahl_mc_headers_b

924:
925: --Update the status to Draft if approval rejected
926: IF (l_status_code = 'APPROVAL_REJECTED')
927: THEN
928: UPDATE ahl_mc_headers_b
929: SET config_status_code = 'DRAFT'
930: WHERE mc_header_id = p_x_rule_rec.mc_header_id;
931: END IF;
932:

Line 1341: UPDATE ahl_mc_headers_b

1337:
1338: --Update the status to Draft if approval rejected
1339: IF (l_status_code = 'APPROVAL_REJECTED')
1340: THEN
1341: UPDATE ahl_mc_headers_b
1342: SET config_status_code = 'DRAFT'
1343: WHERE mc_header_id = l_rule_rec.mc_header_id;
1344: END IF;
1345:

Line 1492: UPDATE ahl_mc_headers_b

1488:
1489: --Update the status to Draft if approval rejected
1490: IF (l_status_code = 'APPROVAL_REJECTED')
1491: THEN
1492: UPDATE ahl_mc_headers_b
1493: SET config_status_code = 'DRAFT'
1494: WHERE mc_header_id = l_mc_header_id;
1495: END IF;
1496: