APPS.PER_RU_CURRENCY_CONVERSION dependencies on HR_ORGANIZATION_INFORMATION

Line 14: hr_organization_information hoi,

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'
18: AND hoi.org_information10 in (cp_old_currency, cp_new_currency)

Line 15: hr_organization_information hoi1

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'
18: AND hoi.org_information10 in (cp_old_currency, cp_new_currency)
19: AND hou.organization_id = hoi.organization_id

Line 611: /* HR_ORGANIZATION_INFORMATION */

607: END IF;
608:
609: END LOOP;
610:
611: /* HR_ORGANIZATION_INFORMATION */
612:
613: UPDATE hr_organization_information
614: SET org_information10 = lv_new_currency
615: WHERE organization_id = ln_business_group_id

Line 613: UPDATE hr_organization_information

609: END LOOP;
610:
611: /* HR_ORGANIZATION_INFORMATION */
612:
613: UPDATE hr_organization_information
614: SET org_information10 = lv_new_currency
615: WHERE organization_id = ln_business_group_id
616: AND org_information_context = 'Business Group Information'
617: AND org_information10 = lv_old_currency;

Line 650: hr_organization_information hoi,

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'
654: AND hoi.org_information10 = 'RUR'

Line 651: hr_organization_information hoi1

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'
654: AND hoi.org_information10 = 'RUR'
655: AND hou.organization_id = hoi.organization_id