APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_FINREPORTS_SG

Line 1336: INSERT INTO HZ_IMP_FINREPORTS_SG

1332: ) IS
1333:
1334: BEGIN
1335: if (P_RERUN = 'Y') then
1336: INSERT INTO HZ_IMP_FINREPORTS_SG
1337: (
1338: PARTY_ID,
1339: PARTY_ORIG_SYSTEM,
1340: PARTY_ORIG_SYSTEM_REFERENCE,

Line 1431: INSERT INTO HZ_IMP_FINREPORTS_SG

1427: and hz_fr1.ACTUAL_CONTENT_SOURCE (+) = P_ACTUAL_CONTENT_SRC))
1428: where new_rank = 1;
1429: else
1430: -- first run
1431: INSERT INTO HZ_IMP_FINREPORTS_SG
1432: (
1433: PARTY_ID,
1434: PARTY_ORIG_SYSTEM,
1435: PARTY_ORIG_SYSTEM_REFERENCE,

Line 1654: hz_imp_finreports_sg frsg,

1650: and fn_int.party_orig_system = mosr.orig_system (+)
1651: and mosr.owner_table_name (+) = 'HZ_PARTIES'
1652: and mosr.status (+) = 'A'
1653: ) fi_pid,
1654: hz_imp_finreports_sg frsg,
1655: hz_financial_reports fr
1656: where fi_pid.pid = frsg.party_id (+)
1657: and fi_pid.type_of_financial_report = frsg.type_of_financial_report (+)
1658: and fi_pid.document_reference = frsg.document_reference (+)

Line 1789: hz_imp_finreports_sg frsg,

1785: and fn_int.party_orig_system = mosr.orig_system (+)
1786: and mosr.owner_table_name (+) = 'HZ_PARTIES'
1787: and mosr.status (+) = 'A'
1788: ) fi_pid,
1789: hz_imp_finreports_sg frsg,
1790: hz_financial_reports fr
1791: where fi_pid.pid = frsg.party_id (+)
1792: and fi_pid.type_of_financial_report = frsg.type_of_financial_report (+)
1793: and fi_pid.document_reference = frsg.document_reference (+)