APPS.JTF_RS_REP_MGR_DENORM_PVT dependencies on JTF_RS_REP_MANAGERS_S

Line 31: SELECT jtf_rs_rep_managers_s.nextval

27: X_MSG_DATA OUT NOCOPY VARCHAR2 )
28: IS
29: CURSOR rep_mgr_seq_cur
30: IS
31: SELECT jtf_rs_rep_managers_s.nextval
32: FROM dual;
33:
34:
35: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

Line 1161: SELECT jtf_rs_rep_managers_s.nextval

1157: X_MSG_DATA OUT NOCOPY VARCHAR2 )
1158: IS
1159: CURSOR rep_mgr_seq_cur
1160: IS
1161: SELECT jtf_rs_rep_managers_s.nextval
1162: FROM dual;
1163:
1164:
1165: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

Line 3029: SELECT jtf_rs_rep_managers_s.nextval

3025: X_MSG_DATA OUT NOCOPY VARCHAR2 )
3026: IS
3027: CURSOR rep_mgr_seq_cur
3028: IS
3029: SELECT jtf_rs_rep_managers_s.nextval
3030: FROM dual;
3031:
3032:
3033: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)

Line 3613: SELECT jtf_rs_rep_managers_s.nextval

3609: IF l_start_date_active > l_end_date_active THEN
3610: RAISE skip_row;
3611: END IF;
3612:
3613: SELECT jtf_rs_rep_managers_s.nextval
3614: INTO l_denorm_manager_id
3615: FROM dual;
3616:
3617: /* to_char(l_process_table(k).PERSON_ID)||'..'||

Line 4164: SELECT jtf_rs_rep_managers_s.nextval

4160: member_rec member_cur%rowtype;
4161:
4162: CURSOR rep_mgr_seq_cur
4163: IS
4164: SELECT jtf_rs_rep_managers_s.nextval
4165: FROM dual;
4166:
4167: --dupliacte check cursor to be added
4168: