DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_RELSHIPS_SG

Line 1852: INSERT INTO HZ_IMP_RELSHIPS_SG

1848: Change the code to use l_no_end_date.
1849: */
1850: if (P_ACTUAL_CONTENT_SRC <> 'USER_ENTERED' and P_RERUN = 'Y') then
1851: -- re-run/DNB
1852: INSERT INTO HZ_IMP_RELSHIPS_SG
1853: ( RELATIONSHIP_TYPE,
1854: RELATIONSHIP_CODE,
1855: START_DATE,
1856: END_DATE,

Line 1964: INSERT INTO HZ_IMP_RELSHIPS_SG

1960:
1961: );
1962: elsif (P_ACTUAL_CONTENT_SRC = 'USER_ENTERED' and P_RERUN = 'Y') then
1963: -- re-run/USER_ENTERED
1964: INSERT INTO HZ_IMP_RELSHIPS_SG
1965: ( RELATIONSHIP_TYPE,
1966: RELATIONSHIP_CODE,
1967: START_DATE,
1968: END_DATE,

Line 2074: INSERT INTO HZ_IMP_RELSHIPS_SG

2070:
2071: );
2072: elsif (P_ACTUAL_CONTENT_SRC <> 'USER_ENTERED' and P_RERUN <> 'Y') then
2073: -- first run/DNB
2074: INSERT INTO HZ_IMP_RELSHIPS_SG
2075: ( RELATIONSHIP_TYPE,
2076: RELATIONSHIP_CODE,
2077: START_DATE,
2078: END_DATE,

Line 2183: INSERT INTO HZ_IMP_RELSHIPS_SG

2179: and ri_ids.subject_osr_change IS NULL /* Bug 5383200 */
2180: );
2181: else
2182: -- first run/non-DNB
2183: INSERT INTO HZ_IMP_RELSHIPS_SG
2184: ( RELATIONSHIP_TYPE,
2185: RELATIONSHIP_CODE,
2186: START_DATE,
2187: END_DATE,