APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_FINREPORTS_SG

Line 1348: INSERT INTO HZ_IMP_FINREPORTS_SG

1344: ) IS
1345:
1346: BEGIN
1347: if (P_RERUN = 'Y') then
1348: INSERT INTO HZ_IMP_FINREPORTS_SG
1349: (
1350: PARTY_ID,
1351: PARTY_ORIG_SYSTEM,
1352: PARTY_ORIG_SYSTEM_REFERENCE,

Line 1444: INSERT INTO HZ_IMP_FINREPORTS_SG

1440: and hz_fr1.ACTUAL_CONTENT_SOURCE (+) = P_ACTUAL_CONTENT_SRC))
1441: where new_rank = 1;
1442: else
1443: -- first run
1444: INSERT INTO HZ_IMP_FINREPORTS_SG
1445: (
1446: PARTY_ID,
1447: PARTY_ORIG_SYSTEM,
1448: PARTY_ORIG_SYSTEM_REFERENCE,

Line 1669: hz_imp_finreports_sg frsg,

1665: and fn_int.party_orig_system = mosr.orig_system (+)
1666: and mosr.owner_table_name (+) = 'HZ_PARTIES'
1667: and mosr.status (+) = 'A'
1668: ) fi_pid,
1669: hz_imp_finreports_sg frsg,
1670: hz_financial_reports fr
1671: where fi_pid.pid = frsg.party_id (+)
1672: and fi_pid.type_of_financial_report = frsg.type_of_financial_report (+)
1673: and fi_pid.document_reference = frsg.document_reference (+)

Line 1805: hz_imp_finreports_sg frsg,

1801: and fn_int.party_orig_system = mosr.orig_system (+)
1802: and mosr.owner_table_name (+) = 'HZ_PARTIES'
1803: and mosr.status (+) = 'A'
1804: ) fi_pid,
1805: hz_imp_finreports_sg frsg,
1806: hz_financial_reports fr
1807: where fi_pid.pid = frsg.party_id (+)
1808: and fi_pid.type_of_financial_report = frsg.type_of_financial_report (+)
1809: and fi_pid.document_reference = frsg.document_reference (+)