APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on HR_ORGANIZATION_UNITS
Line 1026: FROM HR_ORGANIZATION_UNITS
1022:
1023: -- Declare cursor to capture the Organization ID from Business Group ID and Name
1024: CURSOR csr_bg_org_id(p_bg_id NUMBER, p_bg_name VARCHAR2) IS
1025: SELECT organization_id 1026: FROM HR_ORGANIZATION_UNITS 1027: WHERE business_group_id = p_bg_id
1028: AND name = p_bg_name;
1029:
1030: -- Decalare a cursor to fetch the element name