DBA Data[Home] [Help]

APPS.INV_MIGRATE_PROCESS_ORG dependencies on HR_ORGANIZATION_UNITS_S

Line 1112: SELECT hr_organization_units_s.nextval

1108: AND HOU.ORGANIZATION_ID = HOI2.ORGANIZATION_ID
1109: AND ( HOI2.ORG_INFORMATION_CONTEXT || '') ='Accounting Information';
1110:
1111: CURSOR Cur_get_unit IS
1112: SELECT hr_organization_units_s.nextval
1113: FROM dual;
1114:
1115: CURSOR Cur_org_code (v_org_code VARCHAR2, v_start_ch NUMBER) IS
1116: (SELECT substrb(v_org_code,1,v_start_ch)|| substrb(ltrim(to_char(to_number(rownum)-1,'099')), v_start_ch+1)