APPS.CE_BANK_AND_ACCOUNT_VALIDATION dependencies on HR_LOOKUPS

Line 858: bg_org hr_lookups.meaning%TYPE;

854: | IN: |
855: | p_org_id |
856: +=======================================================================*/
857: FUNCTION Get_Org_Type( p_org_id NUMBER ) RETURN VARCHAR2 IS
858: bg_org hr_lookups.meaning%TYPE;
859: le_org hr_lookups.meaning%TYPE;
860: ou_org hr_lookups.meaning%TYPE;
861: org_type1 VARCHAR2(240);
862: org_type VARCHAR2(240);

Line 859: le_org hr_lookups.meaning%TYPE;

855: | p_org_id |
856: +=======================================================================*/
857: FUNCTION Get_Org_Type( p_org_id NUMBER ) RETURN VARCHAR2 IS
858: bg_org hr_lookups.meaning%TYPE;
859: le_org hr_lookups.meaning%TYPE;
860: ou_org hr_lookups.meaning%TYPE;
861: org_type1 VARCHAR2(240);
862: org_type VARCHAR2(240);
863:

Line 860: ou_org hr_lookups.meaning%TYPE;

856: +=======================================================================*/
857: FUNCTION Get_Org_Type( p_org_id NUMBER ) RETURN VARCHAR2 IS
858: bg_org hr_lookups.meaning%TYPE;
859: le_org hr_lookups.meaning%TYPE;
860: ou_org hr_lookups.meaning%TYPE;
861: org_type1 VARCHAR2(240);
862: org_type VARCHAR2(240);
863:
864: CURSOR bg IS

Line 867: hr_lookups hl

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

Line 877: hr_lookups hl

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

Line 887: hr_lookups hl

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

Line 1599: hr_lookups hl

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

Line 1609: hr_lookups hl

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