APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on OZF_PARTY_MARKET_SEGMENTS_T

Line 1331: DELETE FROM OZF_PARTY_MARKET_SEGMENTS_T

1327:
1328: -- mkothari - sep-09-2005 --R12
1329: -- Dump old terr definition into global temp table so that
1330: -- code can identify that account is moved from where to where.
1331: DELETE FROM OZF_PARTY_MARKET_SEGMENTS_T
1332: WHERE market_qualifier_type = 'TERRITORY'
1333: AND market_qualifier_reference = p_terr_id;
1334:
1335: /* --this give GSCC error - "select * not allowed"

Line 1336: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T

1332: WHERE market_qualifier_type = 'TERRITORY'
1333: AND market_qualifier_reference = p_terr_id;
1334:
1335: /* --this give GSCC error - "select * not allowed"
1336: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T
1337: SELECT * FROM AMS_PARTY_MARKET_SEGMENTS OLD_TERR
1338: */
1339: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (
1340: AMS_PARTY_MARKET_SEGMENT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 1339: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (

1335: /* --this give GSCC error - "select * not allowed"
1336: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T
1337: SELECT * FROM AMS_PARTY_MARKET_SEGMENTS OLD_TERR
1338: */
1339: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (
1340: AMS_PARTY_MARKET_SEGMENT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1341: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
1342: OBJECT_VERSION_NUMBER, MARKET_SEGMENT_ID, MARKET_SEGMENT_FLAG,
1343: PARTY_ID, START_DATE_ACTIVE, END_DATE_ACTIVE,

Line 2114: DELETE FROM OZF_PARTY_MARKET_SEGMENTS_T

2110: -- mkothari - sep-09-2005 --R12
2111: -- Dump old terr definition into global temp table so that
2112: -- code can identify that account is moved from where to where.
2113: /*
2114: DELETE FROM OZF_PARTY_MARKET_SEGMENTS_T
2115: WHERE market_qualifier_type = 'TERRITORY';
2116: */
2117:
2118: /* --this give GSCC error - "select * not allowed"

Line 2119: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T

2115: WHERE market_qualifier_type = 'TERRITORY';
2116: */
2117:
2118: /* --this give GSCC error - "select * not allowed"
2119: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T
2120: SELECT * FROM AMS_PARTY_MARKET_SEGMENTS OLD_TERR
2121: */
2122:
2123: /*

Line 2124: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (

2120: SELECT * FROM AMS_PARTY_MARKET_SEGMENTS OLD_TERR
2121: */
2122:
2123: /*
2124: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (
2125: AMS_PARTY_MARKET_SEGMENT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2126: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
2127: OBJECT_VERSION_NUMBER, MARKET_SEGMENT_ID, MARKET_SEGMENT_FLAG,
2128: PARTY_ID, START_DATE_ACTIVE, END_DATE_ACTIVE,