DBA Data[Home] [Help]

APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_SALESREP_NUMBER_S

Line 806: SELECT jtf_rs_salesrep_number_s.nextval

802: IF (l_prof_srp_num = 'EMPLOYEE_NUMBER') THEN
803: l_salesperson_number := l_source_number;
804: ELSIF (l_prof_srp_num = 'SEQUENCE_GENERATED') THEN
805: LOOP
806: SELECT jtf_rs_salesrep_number_s.nextval
807: INTO l_salesperson_number
808: FROM DUAL;
809:
810: OPEN c_salesrep_number(l_salesperson_number);

Line 1123: SELECT jtf_rs_salesrep_number_s.nextval

1119: IF (l_prof_srp_num = 'EMPLOYEE_NUMBER') THEN
1120: l_salesperson_number := l_source_number;
1121: ELSIF (l_prof_srp_num = 'SEQUENCE_GENERATED') THEN
1122: LOOP
1123: SELECT jtf_rs_salesrep_number_s.nextval
1124: INTO l_salesperson_number
1125: FROM DUAL;
1126:
1127: OPEN c_salesrep_number(l_salesperson_number);