DBA Data[Home] [Help]

APPS.JTF_TERR_NAMEACC_PUB dependencies on DUAL

Line 221: SELECT jtf_terr_results_s.nextval into x_session_id FROM sys.dual;

217: */
218: IF (( lx_winners_rec.terr_id.FIRST is not null) OR (TRUNC(lx_winners_rec.terr_id.FIRST)<>'' ))
219: THEN
220: BEGIN
221: SELECT jtf_terr_results_s.nextval into x_session_id FROM sys.dual;
222: FOR i in lx_winners_rec.terr_id.FIRST..lx_winners_rec.terr_id.LAST
223: LOOP
224: -- add processing to find the territory group name
225: -- assumption that territory group is the parent territory of the winning territory