APPS.OPI_DBI_WIP_COMP_INIT_PKG dependencies on HR_ORGANIZATION_INFORMATION

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

974: l_pri_sec_curr_same := 1;
975: END IF;
976:
977: -- By selecting distinct org and currency code from the gl_set_of_books
978: -- and hr_organization_information, take care of duplicate codes.
979: -- Use the fii_currency.get_global_rate_primary function to get the
980: -- conversion rate given a currency code and a date.
981: -- The function returns:
982: -- rate if found

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

992: -- same as the primary, don't call the API but rather use an update
993: -- statement followed by the insert.
994:
995: -- By selecting distinct org and currency code from the gl_set_of_books
996: -- and hr_organization_information, take care of duplicate codes.
997:
998: INSERT /*+ append */
999: INTO opi_dbi_wip_comp_conv_rates rates (
1000: organization_id,

Line 1038: FROM hr_organization_information hoi,

1034: DISTINCT organization_id, transaction_date
1035: FROM opi_dbi_wip_comp_stg) to_conv,
1036: (SELECT
1037: DISTINCT hoi.organization_id, gsob.currency_code
1038: FROM hr_organization_information hoi,
1039: gl_sets_of_books gsob
1040: WHERE hoi.org_information_context = 'Accounting Information'
1041: AND hoi.org_information1 = to_char(gsob.set_of_books_id))
1042: curr_codes