DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CLASSIFICS_SG

Line 951: INSERT INTO HZ_IMP_CLASSIFICS_SG

947:
948: BEGIN
949: if (P_ACTUAL_CONTENT_SRC <> 'USER_ENTERED' and P_RERUN = 'Y') then
950: -- re-run/DNB
951: INSERT INTO HZ_IMP_CLASSIFICS_SG
952: ( CLASS_CATEGORY,
953: CLASS_CODE,
954: START_DATE_ACTIVE,
955: END_DATE_ACTIVE,

Line 1047: INSERT INTO HZ_IMP_CLASSIFICS_SG

1043: and hz_ca3.status (+) = 'A'
1044: );
1045: elsif (P_ACTUAL_CONTENT_SRC = 'USER_ENTERED' and P_RERUN = 'Y') then
1046: -- re-run/NON-DNB
1047: INSERT INTO HZ_IMP_CLASSIFICS_SG
1048: ( CLASS_CATEGORY,
1049: CLASS_CODE,
1050: START_DATE_ACTIVE,
1051: END_DATE_ACTIVE,

Line 1142: INSERT INTO HZ_IMP_CLASSIFICS_SG

1138: and hz_ca3.status (+) = 'A'
1139: );
1140: elsif (P_ACTUAL_CONTENT_SRC <> 'USER_ENTERED' and P_RERUN <> 'Y') then
1141: -- first run/DNB
1142: INSERT INTO HZ_IMP_CLASSIFICS_SG
1143: ( CLASS_CATEGORY,
1144: CLASS_CODE,
1145: START_DATE_ACTIVE,
1146: END_DATE_ACTIVE,

Line 1238: INSERT INTO HZ_IMP_CLASSIFICS_SG

1234: and hz_ca3.status (+) = 'A'
1235: );
1236: else
1237: -- first run/non-DNB
1238: INSERT INTO HZ_IMP_CLASSIFICS_SG
1239: ( CLASS_CATEGORY,
1240: CLASS_CODE,
1241: START_DATE_ACTIVE,
1242: END_DATE_ACTIVE,