DBA Data[Home] [Help]

APPS.AHL_MC_RULE_PVT dependencies on AHL_MC_PATH_POSITION_PVT

Line 156: AHL_MC_PATH_POSITION_PVT.get_posref_by_id(rs.subject_id, FND_API.G_FALSE) POSITION_MEANING,

152: --
153: CURSOR Rule_stmt_csr (p_rulestmt_id IN NUMBER) IS
154: SELECT rs.RULE_STATEMENT_ID,
155: rs.subject_ID POSITION_ID,
156: AHL_MC_PATH_POSITION_PVT.get_posref_by_id(rs.subject_id, FND_API.G_FALSE) POSITION_MEANING,
157: rs.negation_flag,
158: rs.operator,
159: rs.object_version_number,
160: fnd.meaning operator_meaning,

Line 201: SELECT AHL_MC_PATH_POSITION_PVT.get_posref_by_id(p_position_id)

197: FROM MTL_SYSTEM_ITEMS_KFV
198: WHERE INVENTORY_ITEM_ID = p_inv_item_id;
199: --
200: CURSOR get_position_ref_meaning_csr(p_position_id IN NUMBER) IS
201: SELECT AHL_MC_PATH_POSITION_PVT.get_posref_by_id(p_position_id)
202: FROM DUAL;
203: --
204: CURSOR get_mc_name_csr (p_mc_id IN NUMBER) IS
205: SELECT distinct name