DBA Data[Home] [Help]

APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_SALESREP_NUMBER_S

Line 748: SELECT jtf_rs_salesrep_number_s.nextval

744: IF (l_prof_srp_num = 'EMPLOYEE_NUMBER') THEN
745: l_salesperson_number := l_source_number;
746: ELSIF (l_prof_srp_num = 'SEQUENCE_GENERATED') THEN
747: LOOP
748: SELECT jtf_rs_salesrep_number_s.nextval
749: INTO l_salesperson_number
750: FROM DUAL;
751:
752: OPEN c_salesrep_number(l_salesperson_number);

Line 1065: SELECT jtf_rs_salesrep_number_s.nextval

1061: IF (l_prof_srp_num = 'EMPLOYEE_NUMBER') THEN
1062: l_salesperson_number := l_source_number;
1063: ELSIF (l_prof_srp_num = 'SEQUENCE_GENERATED') THEN
1064: LOOP
1065: SELECT jtf_rs_salesrep_number_s.nextval
1066: INTO l_salesperson_number
1067: FROM DUAL;
1068:
1069: OPEN c_salesrep_number(l_salesperson_number);