DBA Data[Home] [Help]

APPS.PAY_MX_CURRENCY_CONVERSION dependencies on HR_ORGANIZATION_UNITS

Line 46: FROM hr_organization_units hou,

42: ) IS
43:
44: CURSOR get_all_bgs( cp_old_currency VARCHAR2 ) IS
45: SELECT hoi.organization_id, hou.name
46: FROM hr_organization_units hou,
47: hr_organization_information hoi,
48: hr_organization_information hoi1
49: WHERE hoi.org_information_context = 'Business Group Information'
50: AND hoi.org_information9 = 'MX'

Line 681: FROM hr_organization_units hou,

677: BEGIN
678:
679: SELECT count(*)
680: INTO ln_conv_curr_cnt
681: FROM hr_organization_units hou,
682: hr_organization_information hoi,
683: hr_organization_information hoi1
684: WHERE hoi.org_information_context = 'Business Group Information'
685: AND hoi.org_information9 = 'MX'