APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on OZF_PARTY_MARKET_SEGMENTS_T

Line 1318: DELETE FROM OZF_PARTY_MARKET_SEGMENTS_T

1314:
1315: -- mkothari - sep-09-2005 --R12
1316: -- Dump old terr definition into global temp table so that
1317: -- code can identify that account is moved from where to where.
1318: DELETE FROM OZF_PARTY_MARKET_SEGMENTS_T
1319: WHERE market_qualifier_type = 'TERRITORY'
1320: AND market_qualifier_reference = p_terr_id;
1321:
1322: /* --this give GSCC error - "select * not allowed"

Line 1323: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T

1319: WHERE market_qualifier_type = 'TERRITORY'
1320: AND market_qualifier_reference = p_terr_id;
1321:
1322: /* --this give GSCC error - "select * not allowed"
1323: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T
1324: SELECT * FROM AMS_PARTY_MARKET_SEGMENTS OLD_TERR
1325: */
1326: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (
1327: AMS_PARTY_MARKET_SEGMENT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 1326: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (

1322: /* --this give GSCC error - "select * not allowed"
1323: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T
1324: SELECT * FROM AMS_PARTY_MARKET_SEGMENTS OLD_TERR
1325: */
1326: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (
1327: AMS_PARTY_MARKET_SEGMENT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1328: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
1329: OBJECT_VERSION_NUMBER, MARKET_SEGMENT_ID, MARKET_SEGMENT_FLAG,
1330: PARTY_ID, START_DATE_ACTIVE, END_DATE_ACTIVE,

Line 2101: DELETE FROM OZF_PARTY_MARKET_SEGMENTS_T

2097: -- mkothari - sep-09-2005 --R12
2098: -- Dump old terr definition into global temp table so that
2099: -- code can identify that account is moved from where to where.
2100: /*
2101: DELETE FROM OZF_PARTY_MARKET_SEGMENTS_T
2102: WHERE market_qualifier_type = 'TERRITORY';
2103: */
2104:
2105: /* --this give GSCC error - "select * not allowed"

Line 2106: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T

2102: WHERE market_qualifier_type = 'TERRITORY';
2103: */
2104:
2105: /* --this give GSCC error - "select * not allowed"
2106: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T
2107: SELECT * FROM AMS_PARTY_MARKET_SEGMENTS OLD_TERR
2108: */
2109:
2110: /*

Line 2111: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (

2107: SELECT * FROM AMS_PARTY_MARKET_SEGMENTS OLD_TERR
2108: */
2109:
2110: /*
2111: INSERT INTO OZF_PARTY_MARKET_SEGMENTS_T (
2112: AMS_PARTY_MARKET_SEGMENT_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2113: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
2114: OBJECT_VERSION_NUMBER, MARKET_SEGMENT_ID, MARKET_SEGMENT_FLAG,
2115: PARTY_ID, START_DATE_ACTIVE, END_DATE_ACTIVE,