APPS.MSD_STRIPE_DEMAND_PLAN dependencies on MSD_LEVEL_ORG_ASSCNS

Line 952: from msd_level_org_asscns mlo,

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

Line 1071: from msd_level_org_asscns mlo,

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

Line 1135: msd_level_org_asscns mloa,

1131: mlv.system_attribute1,
1132: mlv.system_attribute2,
1133: mlv.dp_enabled_flag
1134: FROM msd_dp_iso_organizations mdio,
1135: msd_level_org_asscns mloa,
1136: msd_level_values mlv
1137: WHERE
1138: mdio.demand_plan_id = p_demand_plan_id
1139: AND mloa.instance = mdio.sr_instance_id

Line 3414: msd_level_org_asscns mloa

3410: SELECT 1
3411: FROM dual
3412: WHERE EXISTS (SELECT mloa.sr_level_pk
3413: FROM msd_dp_iso_organizations mdio,
3414: msd_level_org_asscns mloa
3415: WHERE
3416: mdio.demand_plan_id = p_demand_plan_id
3417: AND mloa.instance = mdio.sr_instance_id
3418: AND mloa.level_id = 11

Line 3443: msd_level_org_asscns mloa

3439: AND level_id = 11
3440: MINUS
3441: SELECT mloa.sr_level_pk
3442: FROM msd_dp_iso_organizations mdio,
3443: msd_level_org_asscns mloa
3444: WHERE
3445: mdio.demand_plan_id = p_demand_plan_id
3446: AND mloa.instance = mdio.sr_instance_id
3447: AND mloa.level_id = 11