APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on HR_ORGANIZATION_INFORMATION

Line 866: FROM hr_organization_information oi,

862: org_type VARCHAR2(240);
863:
864: CURSOR bg IS
865: SELECT hl.meaning || ', '
866: FROM hr_organization_information oi,
867: hr_lookups hl
868: WHERE oi.org_information_context = 'CLASS'
869: AND oi.org_information1 = 'HR_BG'
870: and hl.lookup_type = 'ORG_CLASS'

Line 876: FROM hr_organization_information oi,

872: and oi.organization_id = p_org_id;
873:
874: CURSOR le IS
875: SELECT hl.meaning || ', '
876: FROM hr_organization_information oi,
877: hr_lookups hl
878: WHERE oi.org_information_context = 'CLASS'
879: AND oi.org_information1 = 'HR_LEGAL'
880: and hl.lookup_type = 'ORG_CLASS'

Line 886: FROM hr_organization_information oi,

882: and oi.organization_id = p_org_id;
883:
884: CURSOR ou IS
885: SELECT hl.meaning || ', '
886: FROM hr_organization_information oi,
887: hr_lookups hl
888: WHERE oi.org_information_context = 'CLASS'
889: AND oi.org_information1 = 'OPERATING_UNIT'
890: and hl.lookup_type = 'ORG_CLASS'

Line 1598: FROM hr_organization_information oi,

1594: ou_org VARCHAR2(50);
1595:
1596: CURSOR bg IS
1597: SELECT 'BG'
1598: FROM hr_organization_information oi,
1599: hr_lookups hl
1600: WHERE oi.org_information_context = 'CLASS'
1601: AND oi.org_information1 = 'HR_BG'
1602: and hl.lookup_type = 'ORG_CLASS'

Line 1608: FROM hr_organization_information oi,

1604: and oi.organization_id = p_org_id;
1605:
1606: CURSOR ou IS
1607: SELECT 'OU'
1608: FROM hr_organization_information oi,
1609: hr_lookups hl
1610: WHERE oi.org_information_context = 'CLASS'
1611: AND oi.org_information1 = 'OPERATING_UNIT'
1612: and hl.lookup_type = 'ORG_CLASS'