APPS.AHL_UC_INSTANCE_PVT dependencies on AHL_MC_CONFIG_RELATIONS

Line 2336: FROM ahl_mc_config_relations

2332: FROM ahl_mc_relationships
2333: WHERE relationship_id = c_child_relationship_id
2334: AND (parent_relationship_id = c_parent_relationship_id OR
2335: mc_header_id IN (SELECT mc_header_id
2336: FROM ahl_mc_config_relations
2337: WHERE relationship_id = c_parent_relationship_id
2338: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
2339: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)));
2340:

Line 2395: FROM ahl_mc_config_relations

2391: AND trunc(nvl(R.active_end_date, SYSDATE+1)) > trunc(SYSDATE)
2392: AND H.name = c_mc_name
2393: AND H.revision = c_mc_revision
2394: AND H.mc_header_id IN (SELECT mc_header_id
2395: FROM ahl_mc_config_relations
2396: WHERE relationship_id = c_relationship_id
2397: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
2398: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE));
2399:

Line 3407: FROM ahl_mc_config_relations

3403: FROM ahl_mc_relationships
3404: WHERE relationship_id = c_child_relationship_id
3405: AND (parent_relationship_id = c_parent_relationship_id OR
3406: mc_header_id IN (SELECT mc_header_id
3407: FROM ahl_mc_config_relations
3408: WHERE relationship_id = c_parent_relationship_id
3409: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
3410: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE)));
3411:

Line 3536: FROM ahl_mc_config_relations

3532: l_instance_rec csi_item_instance_csr%ROWTYPE;
3533:
3534: CURSOR check_sub_mc(c_relationship_id NUMBER) IS
3535: SELECT mc_header_id
3536: FROM ahl_mc_config_relations
3537: WHERE relationship_id = c_relationship_id
3538: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
3539: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
3540:

Line 4775: FROM ahl_mc_config_relations R

4771: -- Check to see this UC is a subconfig
4772: --
4773: AND EXISTS (
4774: SELECT 1
4775: FROM ahl_mc_config_relations R
4776: WHERE R.mc_header_id = U.mc_header_id
4777: AND R.relationship_id = c_relationship_id
4778: AND trunc(nvl(R.active_start_date, SYSDATE)) <= trunc(SYSDATE)
4779: AND trunc(nvl(R.active_end_date, SYSDATE+1)) > trunc(SYSDATE)

Line 5519: FROM ahl_mc_config_relations R

5515: --Either JOIN or IN, performance cost is bigger than EXISTS
5516: AND EXISTS
5517: (
5518: SELECT 1
5519: FROM ahl_mc_config_relations R
5520: WHERE R.mc_header_id = U.mc_header_id
5521: AND R.relationship_id = c_relationship_id
5522: AND trunc(nvl(R.active_start_date, SYSDATE)) <= trunc(SYSDATE)
5523: AND trunc(nvl(R.active_end_date, SYSDATE+1)) > trunc(SYSDATE)