APPS.MSC_CALENDAR dependencies on MSC_TRADING_PARTNERS

Line 589: FROM msc_trading_partners

585: calendar_code,
586: calendar_exception_set_id
587: INTO arg_calendar_code,
588: arg_exception_set_id
589: FROM msc_trading_partners
590: WHERE sr_tp_id = l_org_id
591: AND partner_type = 3
592: AND sr_instance_id = arg_instance_id;
593:

Line 1111: FROM MSC_TRADING_PARTNERS

1107: ELSIF (p_calendar_type = MSC_CALENDAR.OMC) THEN
1108:
1109: SELECT calendar_code, C_ORGANIZATION
1110: INTO l_calendar_code, p_association_type
1111: FROM MSC_TRADING_PARTNERS
1112: WHERE SR_INSTANCE_ID = p_instance_id
1113: AND PARTNER_TYPE = 3
1114: AND SR_TP_ID = p_organization_id;
1115:

Line 1133: FROM MSC_TRADING_PARTNERS

1129: IF (p_calendar_type = MSC_CALENDAR.ORC OR p_calendar_type = MSC_CALENDAR.OSC) THEN
1130: -- Return OMC.
1131: SELECT calendar_code, C_ORGANIZATION
1132: INTO l_calendar_code, p_association_type
1133: FROM MSC_TRADING_PARTNERS
1134: WHERE SR_INSTANCE_ID = p_instance_id
1135: AND PARTNER_TYPE = 3
1136: AND SR_TP_ID = p_organization_id;
1137: END IF;

Line 1286: FROM MSC_TRADING_PARTNERS

1282: ELSIF (p_calendar_type = MSC_CALENDAR.OMC) THEN
1283:
1284: SELECT calendar_code, C_ORGANIZATION
1285: INTO l_calendar_code, p_association_type
1286: FROM MSC_TRADING_PARTNERS
1287: WHERE SR_INSTANCE_ID = p_instance_id
1288: AND PARTNER_TYPE = 3
1289: AND SR_TP_ID = p_organization_id;
1290: END IF;

Line 1304: FROM MSC_TRADING_PARTNERS

1300: IF (p_calendar_type = MSC_CALENDAR.ORC OR p_calendar_type = MSC_CALENDAR.OSC) THEN
1301: -- Return OMC.
1302: SELECT calendar_code, C_ORGANIZATION
1303: INTO l_calendar_code, p_association_type
1304: FROM MSC_TRADING_PARTNERS
1305: WHERE SR_INSTANCE_ID = p_instance_id
1306: AND PARTNER_TYPE = 3
1307: AND SR_TP_ID = p_organization_id;
1308: END IF;