APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_LEVEL_ORG_ASSCNS

Line 949: from msd_level_org_asscns mlo,

945: fnd_global.user_id,
946: mlv.system_attribute1,
947: mlv.system_attribute2,
948: mlv.dp_enabled_flag
949: from msd_level_org_asscns mlo,
950: msd_level_values mlv,
951: msd_level_values_ds_temp mld
952: where mld.demand_plan_id = p_demand_plan_id
953: and mlo.instance = mld.instance

Line 1068: from msd_level_org_asscns mlo,

1064: fnd_global.user_id,
1065: mlv.system_attribute1,
1066: mlv.system_attribute2,
1067: mlv.dp_enabled_flag
1068: from msd_level_org_asscns mlo,
1069: msd_level_values mlv,
1070: msd_level_values_ds_temp mld
1071: where mld.demand_plan_id = p_demand_plan_id
1072: and mlo.instance = mld.instance

Line 1129: msd_level_org_asscns mloa,

1125: mlv.system_attribute1,
1126: mlv.system_attribute2,
1127: mlv.dp_enabled_flag
1128: FROM msd_dp_iso_organizations mdio,
1129: msd_level_org_asscns mloa,
1130: msd_level_values mlv
1131: WHERE
1132: mdio.demand_plan_id = p_demand_plan_id
1133: AND mloa.instance = mdio.sr_instance_id

Line 3408: msd_level_org_asscns mloa

3404: SELECT 1
3405: FROM dual
3406: WHERE EXISTS (SELECT mloa.sr_level_pk
3407: FROM msd_dp_iso_organizations mdio,
3408: msd_level_org_asscns mloa
3409: WHERE
3410: mdio.demand_plan_id = p_demand_plan_id
3411: AND mloa.instance = mdio.sr_instance_id
3412: AND mloa.level_id = 11

Line 3437: msd_level_org_asscns mloa

3433: AND level_id = 11
3434: MINUS
3435: SELECT mloa.sr_level_pk
3436: FROM msd_dp_iso_organizations mdio,
3437: msd_level_org_asscns mloa
3438: WHERE
3439: mdio.demand_plan_id = p_demand_plan_id
3440: AND mloa.instance = mdio.sr_instance_id
3441: AND mloa.level_id = 11