APPS.PER_ZA_USER_HOOK_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 673: FROM HR_ORGANIZATION_INFORMATION

669:
670: CURSOR c_org_info
671: IS
672: SELECT ORG_INFORMATION2
673: FROM HR_ORGANIZATION_INFORMATION
674: WHERE ORG_INFORMATION_CONTEXT = 'Business Group Information'
675: AND organization_id = p_business_group_id ;
676:
677: -- Bug#12674949

Line 1083: FROM HR_ORGANIZATION_INFORMATION

1079:
1080: CURSOR c_org_info
1081: IS
1082: SELECT ORG_INFORMATION2
1083: FROM HR_ORGANIZATION_INFORMATION
1084: WHERE ORG_INFORMATION_CONTEXT = 'Business Group Information'
1085: AND ORGANIZATION_ID = (SELECT BUSINESS_GROUP_ID
1086: FROM PER_ALL_PEOPLE_F
1087: WHERE PERSON_ID = p_person_id

Line 1818: l_sdl_num hr_organization_information.org_information12%type; -- 9864910 fix

1814: ,p_org_information15 IN VARCHAR2 -- 9864910 fix
1815: ,p_org_information16 IN VARCHAR2 -- 9864910 fix
1816: ,p_org_information17 IN VARCHAR2 -- 9815318 fix
1817: )as
1818: l_sdl_num hr_organization_information.org_information12%type; -- 9864910 fix
1819: l_uif_num hr_organization_information.org_information6%type; -- 9864910 fix
1820: begin
1821: -- Org Info Type : ZA_GRE_TAX_FILE_ENTITY
1822: if p_org_info_type_code = 'ZA_GRE_TAX_FILE_ENTITY' then

Line 1819: l_uif_num hr_organization_information.org_information6%type; -- 9864910 fix

1815: ,p_org_information16 IN VARCHAR2 -- 9864910 fix
1816: ,p_org_information17 IN VARCHAR2 -- 9815318 fix
1817: )as
1818: l_sdl_num hr_organization_information.org_information12%type; -- 9864910 fix
1819: l_uif_num hr_organization_information.org_information6%type; -- 9864910 fix
1820: begin
1821: -- Org Info Type : ZA_GRE_TAX_FILE_ENTITY
1822: if p_org_info_type_code = 'ZA_GRE_TAX_FILE_ENTITY' then
1823: if validate_charcter_set(p_org_information1,'ALPHA') = false then