APPS.JTF_RS_REP_MGR_DENORM_PVT dependencies on DUAL

Line 32: FROM dual;

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)
36: IS

Line 1162: FROM dual;

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)
1166: IS

Line 3030: FROM dual;

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)
3034: IS

Line 3615: FROM dual;

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)||'..'||
3618: l_process_table(k).CATEGORY||'..'||
3619: to_char(l_process_table(k).MANAGER_PERSON_ID)||'..'||

Line 4165: FROM dual;

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:
4169: CURSOR dup_cur2(l_par_role_relate_id JTF_RS_ROLE_RELATIONS.ROLE_RELATE_ID%TYPE,