APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on HR_ORGANIZATION_INFORMATION

Line 902: l_org_information_id HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_ID%TYPE;

898:
899: l_verify_org_info NUMBER;
900:
901: -- OUT Variables
902: l_org_information_id HR_ORGANIZATION_INFORMATION.ORG_INFORMATION_ID%TYPE;
903: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE;
904:
905:
906:

Line 912: FROM HR_ORGANIZATION_INFORMATION

908: BEGIN
909: p_retcode :=0;/* Setting initial value*/
910:
911: SELECT COUNT(*) INTO l_verify_org_info
912: FROM HR_ORGANIZATION_INFORMATION
913: WHERE organization_id = p_org_id
914: AND org_information_context = p_org_info_type;
915:
916: