APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on HR_ORGANIZATION_INFORMATION

Line 851: FROM hr_organization_information oi,

847: org_type VARCHAR2(240);
848:
849: CURSOR bg IS
850: SELECT hl.meaning || ', '
851: FROM hr_organization_information oi,
852: hr_lookups hl
853: WHERE oi.org_information_context = 'CLASS'
854: AND oi.org_information1 = 'HR_BG'
855: and hl.lookup_type = 'ORG_CLASS'

Line 861: FROM hr_organization_information oi,

857: and oi.organization_id = p_org_id;
858:
859: CURSOR le IS
860: SELECT hl.meaning || ', '
861: FROM hr_organization_information oi,
862: hr_lookups hl
863: WHERE oi.org_information_context = 'CLASS'
864: AND oi.org_information1 = 'HR_LEGAL'
865: and hl.lookup_type = 'ORG_CLASS'

Line 871: FROM hr_organization_information oi,

867: and oi.organization_id = p_org_id;
868:
869: CURSOR ou IS
870: SELECT hl.meaning || ', '
871: FROM hr_organization_information oi,
872: hr_lookups hl
873: WHERE oi.org_information_context = 'CLASS'
874: AND oi.org_information1 = 'OPERATING_UNIT'
875: and hl.lookup_type = 'ORG_CLASS'

Line 1583: FROM hr_organization_information oi,

1579: ou_org VARCHAR2(50);
1580:
1581: CURSOR bg IS
1582: SELECT 'BG'
1583: FROM hr_organization_information oi,
1584: hr_lookups hl
1585: WHERE oi.org_information_context = 'CLASS'
1586: AND oi.org_information1 = 'HR_BG'
1587: and hl.lookup_type = 'ORG_CLASS'

Line 1593: FROM hr_organization_information oi,

1589: and oi.organization_id = p_org_id;
1590:
1591: CURSOR ou IS
1592: SELECT 'OU'
1593: FROM hr_organization_information oi,
1594: hr_lookups hl
1595: WHERE oi.org_information_context = 'CLASS'
1596: AND oi.org_information1 = 'OPERATING_UNIT'
1597: and hl.lookup_type = 'ORG_CLASS'