APPS.AHL_UC_POS_NECES_PVT dependencies on AHL_APPLICABLE_INSTANCES

Line 963: AHL_APPLICABLE_INSTANCES ap

959:
960: CURSOR rule_exists_csr IS
961: SELECT distinct rul.rule_id, rul.rule_name, rul.mc_header_id
962: FROM AHL_MC_RULES_B rul, AHL_MC_RULE_STATEMENTS rst,
963: AHL_APPLICABLE_INSTANCES ap
964: WHERE rst.rule_id = rul.rule_id
965: AND rul.rule_type_code = 'MANDATORY'
966: AND rst.subject_type = 'POSITION'
967: AND rst.subject_id = ap.position_id

Line 1013: EXECUTE IMMEDIATE 'DELETE FROM AHL_APPLICABLE_INSTANCES';

1009: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin',
1011: 'At the start of the function, p_instance_id = ' || p_instance_id);
1012: END IF;
1013: EXECUTE IMMEDIATE 'DELETE FROM AHL_APPLICABLE_INSTANCES';
1014: -- Get all the Position Paths associated with the instance p_instance_id into AHL_APPLICABLE_INSTANCES.
1015: -- If there is a configuration like A.1-B.1-C.1 and path positions exist for C.1, B.1-C.1, A.1-B.1-C.1 all these
1016: -- will be picked up after the call below
1017: AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Positions(p_api_version => 1.0,

Line 1014: -- Get all the Position Paths associated with the instance p_instance_id into AHL_APPLICABLE_INSTANCES.

1010: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin',
1011: 'At the start of the function, p_instance_id = ' || p_instance_id);
1012: END IF;
1013: EXECUTE IMMEDIATE 'DELETE FROM AHL_APPLICABLE_INSTANCES';
1014: -- Get all the Position Paths associated with the instance p_instance_id into AHL_APPLICABLE_INSTANCES.
1015: -- If there is a configuration like A.1-B.1-C.1 and path positions exist for C.1, B.1-C.1, A.1-B.1-C.1 all these
1016: -- will be picked up after the call below
1017: AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Positions(p_api_version => 1.0,
1018: x_return_status => l_return_status,