DBA Data[Home] [Help]

APPS.PER_RU_CURRENCY_CONVERSION dependencies on HR_ORGANIZATION_UNITS

Line 13: FROM hr_organization_units hou,

9: ) IS
10:
11: CURSOR get_all_bgs( cp_old_currency VARCHAR2, cp_new_currency VARCHAR2 ) IS
12: SELECT hoi.organization_id, hou.name
13: FROM hr_organization_units hou,
14: hr_organization_information hoi,
15: hr_organization_information hoi1
16: WHERE hoi.org_information_context = 'Business Group Information'
17: AND hoi.org_information9 = 'RU'

Line 649: FROM hr_organization_units hou,

645: BEGIN
646:
647: SELECT count(*)
648: INTO ln_conv_curr_cnt
649: FROM hr_organization_units hou,
650: hr_organization_information hoi,
651: hr_organization_information hoi1
652: WHERE hoi.org_information_context = 'Business Group Information'
653: AND hoi.org_information9 = 'RU'