APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on HR_LOOKUPS

Line 843: bg_org hr_lookups.meaning%TYPE;

839: | IN: |
840: | p_org_id |
841: +=======================================================================*/
842: FUNCTION Get_Org_Type( p_org_id NUMBER ) RETURN VARCHAR2 IS
843: bg_org hr_lookups.meaning%TYPE;
844: le_org hr_lookups.meaning%TYPE;
845: ou_org hr_lookups.meaning%TYPE;
846: org_type1 VARCHAR2(240);
847: org_type VARCHAR2(240);

Line 844: le_org hr_lookups.meaning%TYPE;

840: | p_org_id |
841: +=======================================================================*/
842: FUNCTION Get_Org_Type( p_org_id NUMBER ) RETURN VARCHAR2 IS
843: bg_org hr_lookups.meaning%TYPE;
844: le_org hr_lookups.meaning%TYPE;
845: ou_org hr_lookups.meaning%TYPE;
846: org_type1 VARCHAR2(240);
847: org_type VARCHAR2(240);
848:

Line 845: ou_org hr_lookups.meaning%TYPE;

841: +=======================================================================*/
842: FUNCTION Get_Org_Type( p_org_id NUMBER ) RETURN VARCHAR2 IS
843: bg_org hr_lookups.meaning%TYPE;
844: le_org hr_lookups.meaning%TYPE;
845: ou_org hr_lookups.meaning%TYPE;
846: org_type1 VARCHAR2(240);
847: org_type VARCHAR2(240);
848:
849: CURSOR bg IS

Line 852: hr_lookups hl

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'
856: AND hl.lookup_code = oi.org_information1

Line 862: hr_lookups hl

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'
866: AND hl.lookup_code = oi.org_information1

Line 872: hr_lookups hl

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'
876: AND hl.lookup_code = oi.org_information1

Line 1584: hr_lookups hl

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'
1588: AND hl.lookup_code = oi.org_information1

Line 1594: hr_lookups hl

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'
1598: AND hl.lookup_code = oi.org_information1