APPS.PAY_MX_CURRENCY_CONVERSION dependencies on HR_ORGANIZATION_INFORMATION

Line 47: hr_organization_information hoi,

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'
51: AND hoi.org_information10 = cp_old_currency

Line 48: hr_organization_information hoi1

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'
51: AND hoi.org_information10 = cp_old_currency
52: AND hou.organization_id = hoi.organization_id

Line 644: /* HR_ORGANIZATION_INFORMATION */

640: END IF;
641:
642: END LOOP;
643:
644: /* HR_ORGANIZATION_INFORMATION */
645:
646: UPDATE hr_organization_information
647: SET org_information10 = lv_new_currency
648: WHERE organization_id = ln_business_group_id

Line 646: UPDATE hr_organization_information

642: END LOOP;
643:
644: /* HR_ORGANIZATION_INFORMATION */
645:
646: UPDATE hr_organization_information
647: SET org_information10 = lv_new_currency
648: WHERE organization_id = ln_business_group_id
649: AND org_information_context = 'Business Group Information'
650: AND org_information10 = lv_old_currency;

Line 682: hr_organization_information hoi,

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'
686: AND hoi.org_information10 = 'MXP'

Line 683: hr_organization_information hoi1

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'
686: AND hoi.org_information10 = 'MXP'
687: AND hou.organization_id = hoi.organization_id