DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CLASSIFICS_SG

Line 943: INSERT INTO HZ_IMP_CLASSIFICS_SG

939:
940: BEGIN
941: if (P_ACTUAL_CONTENT_SRC <> 'USER_ENTERED' and P_RERUN = 'Y') then
942: -- re-run/DNB
943: INSERT INTO HZ_IMP_CLASSIFICS_SG
944: ( CLASS_CATEGORY,
945: CLASS_CODE,
946: START_DATE_ACTIVE,
947: END_DATE_ACTIVE,

Line 1038: INSERT INTO HZ_IMP_CLASSIFICS_SG

1034: and hz_ca3.status (+) = 'A'
1035: );
1036: elsif (P_ACTUAL_CONTENT_SRC = 'USER_ENTERED' and P_RERUN = 'Y') then
1037: -- re-run/NON-DNB
1038: INSERT INTO HZ_IMP_CLASSIFICS_SG
1039: ( CLASS_CATEGORY,
1040: CLASS_CODE,
1041: START_DATE_ACTIVE,
1042: END_DATE_ACTIVE,

Line 1132: INSERT INTO HZ_IMP_CLASSIFICS_SG

1128: and hz_ca3.status (+) = 'A'
1129: );
1130: elsif (P_ACTUAL_CONTENT_SRC <> 'USER_ENTERED' and P_RERUN <> 'Y') then
1131: -- first run/DNB
1132: INSERT INTO HZ_IMP_CLASSIFICS_SG
1133: ( CLASS_CATEGORY,
1134: CLASS_CODE,
1135: START_DATE_ACTIVE,
1136: END_DATE_ACTIVE,

Line 1227: INSERT INTO HZ_IMP_CLASSIFICS_SG

1223: and hz_ca3.status (+) = 'A'
1224: );
1225: else
1226: -- first run/non-DNB
1227: INSERT INTO HZ_IMP_CLASSIFICS_SG
1228: ( CLASS_CATEGORY,
1229: CLASS_CODE,
1230: START_DATE_ACTIVE,
1231: END_DATE_ACTIVE,