APPS.AHL_MC_MASTERCONFIG_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 875: FROM ahl_unit_config_headers

871: p_mc_header_id in number
872: )
873: IS
874: SELECT 'x'
875: FROM ahl_unit_config_headers
876: WHERE master_config_id = p_mc_header_id AND
877: trunc(nvl(active_end_date, G_SYSDATE + 1)) > G_TRUNC_DATE;
878:
879: /*

Line 881: FROM ahl_mc_relationships mcr, ahl_unit_config_headers uch

877: trunc(nvl(active_end_date, G_SYSDATE + 1)) > G_TRUNC_DATE;
878:
879: /*
880: SELECT 'x'
881: FROM ahl_mc_relationships mcr, ahl_unit_config_headers uch
882: WHERE mcr.mc_header_id = p_mc_header_id AND
883: mcr.parent_relationship_id IS NULL AND
884: uch.master_config_id = mcr.relationship_id AND
885: trunc(nvl(uch.active_end_date, G_SYSDATE + 1)) > G_TRUNC_DATE;