DBA Data[Home] [Help]

APPS.INV_MIGRATE_PROCESS_ORG dependencies on HR_ORGANIZATION_UNITS_S

Line 1110: SELECT hr_organization_units_s.nextval

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