DBA Data[Home] [Help]

APPS.JTF_TTY_CREATE_TERR_FROM_GEO dependencies on JTF_TERR_RSC_ACCESS_S

Line 459: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL

455: FOR rsc_acc IN c_role_access(l_geo_terr_group_id, tran_type.role_code) LOOP
456: --dbms_output.put_line('acc_type:'||rsc_acc.access_type);
457:
458: /* get the sequence */
459: SELECT JTF_TERR_RSC_ACCESS_S.NEXTVAL
460: INTO l_terr_rsc_access_id
461: FROM DUAL;
462:
463: /* commented this as all the types are found to be same