APPS.OPI_DBI_WIP_SCRAP_INIT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 940: -- and hr_organization_information, take care of duplicate codes.

936: l_pri_sec_curr_same := 1;
937: END IF;
938:
939: -- By selecting distinct org and currency code from the gl_set_of_books
940: -- and hr_organization_information, take care of duplicate codes.
941: -- Use the fii_currency.get_global_rate_primary function to get the
942: -- conversion rate given a currency code and a date.
943: -- The function returns:
944: -- rate if found

Line 958: -- and hr_organization_information, take care of duplicate codes.

954: -- same as the primary, don't call the API but rather use an update
955: -- statement followed by the insert.
956:
957: -- By selecting distinct org and currency code from the gl_set_of_books
958: -- and hr_organization_information, take care of duplicate codes.
959:
960: INSERT /*+ append */
961: INTO opi_dbi_wip_scrap_conv_rates rates (
962: organization_id,

Line 1000: FROM hr_organization_information hoi,

996: DISTINCT organization_id, transaction_date
997: FROM opi_dbi_wip_scrap_stg) to_conv,
998: (SELECT
999: DISTINCT hoi.organization_id, gsob.currency_code
1000: FROM hr_organization_information hoi,
1001: gl_sets_of_books gsob
1002: WHERE hoi.org_information_context = 'Accounting Information'
1003: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
1004: curr_codes