APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_RELSHIPS_SG

Line 1836: INSERT INTO HZ_IMP_RELSHIPS_SG

1832: Change the code to use l_no_end_date.
1833: */
1834: if (P_ACTUAL_CONTENT_SRC <> 'USER_ENTERED' and P_RERUN = 'Y') then
1835: -- re-run/DNB
1836: INSERT INTO HZ_IMP_RELSHIPS_SG
1837: ( RELATIONSHIP_TYPE,
1838: RELATIONSHIP_CODE,
1839: START_DATE,
1840: END_DATE,

Line 1944: INSERT INTO HZ_IMP_RELSHIPS_SG

1940: and hz_rel.subject_table_name (+) = 'HZ_PARTIES'
1941: );
1942: elsif (P_ACTUAL_CONTENT_SRC = 'USER_ENTERED' and P_RERUN = 'Y') then
1943: -- re-run/USER_ENTERED
1944: INSERT INTO HZ_IMP_RELSHIPS_SG
1945: ( RELATIONSHIP_TYPE,
1946: RELATIONSHIP_CODE,
1947: START_DATE,
1948: END_DATE,

Line 2050: INSERT INTO HZ_IMP_RELSHIPS_SG

2046: and hz_rel.subject_table_name (+) = 'HZ_PARTIES'
2047: );
2048: elsif (P_ACTUAL_CONTENT_SRC <> 'USER_ENTERED' and P_RERUN <> 'Y') then
2049: -- first run/DNB
2050: INSERT INTO HZ_IMP_RELSHIPS_SG
2051: ( RELATIONSHIP_TYPE,
2052: RELATIONSHIP_CODE,
2053: START_DATE,
2054: END_DATE,

Line 2156: INSERT INTO HZ_IMP_RELSHIPS_SG

2152: and hz_rel.subject_table_name (+) = 'HZ_PARTIES'
2153: );
2154: else
2155: -- first run/non-DNB
2156: INSERT INTO HZ_IMP_RELSHIPS_SG
2157: ( RELATIONSHIP_TYPE,
2158: RELATIONSHIP_CODE,
2159: START_DATE,
2160: END_DATE,