APPS.JTF_RS_REP_MGR_DENORM_PVT dependencies on DUAL

Line 31: FROM dual;

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

Line 1161: FROM dual;

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

Line 3017: FROM dual;

3013: IS
3014: CURSOR rep_mgr_seq_cur
3015: IS
3016: SELECT jtf_rs_rep_managers_s.nextval
3017: FROM dual;
3018:
3019:
3020: CURSOR mem_dtls_cur(l_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE)
3021: IS

Line 3602: FROM dual;

3598: END IF;
3599:
3600: SELECT jtf_rs_rep_managers_s.nextval
3601: INTO l_denorm_manager_id
3602: FROM dual;
3603:
3604: /* to_char(l_process_table(k).PERSON_ID)||'..'||
3605: l_process_table(k).CATEGORY||'..'||
3606: to_char(l_process_table(k).MANAGER_PERSON_ID)||'..'||

Line 4152: FROM dual;

4148:
4149: CURSOR rep_mgr_seq_cur
4150: IS
4151: SELECT jtf_rs_rep_managers_s.nextval
4152: FROM dual;
4153:
4154: --dupliacte check cursor to be added
4155:
4156: CURSOR dup_cur2(l_par_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,