APPS.AHL_MC_MASTERCONFIG_PVT dependencies on AHL_MC_CONFIG_RELATIONS

Line 853: FROM ahl_mc_config_relations

849: p_mc_header_id in number
850: )
851: IS
852: SELECT 'x'
853: FROM ahl_mc_config_relations
854: WHERE mc_header_id = p_mc_header_id;
855:
856: -- Define get_mc_topnode_details to read the details of the MC topnode
857: CURSOR get_mc_topnode_details

Line 2969: FROM ahl_mc_config_relations mccr, ahl_mc_headers_b mch

2965: p_relationship_id IN NUMBER
2966: )
2967: IS
2968: SELECT mch.name, mch.config_status_code
2969: FROM ahl_mc_config_relations mccr, ahl_mc_headers_b mch
2970: WHERE mccr.relationship_id = p_relationship_id AND
2971: mccr.mc_header_id = mch.mc_header_id;
2972: -- Since expired subconfig associations can be unexpired, so no need to filter on active_end_date
2973: -- AND trunc(nvl(mccr.active_end_date, G_SYSDATE + 1)) > G_TRUNC_DATE;