APPS.ZPB_DC_WF dependencies on DUAL

Line 673: FROM dual;

669:
670:
671: SELECT ZPB_DC_WF_PROCESSES_S.nextval
672: INTO l_sequence
673: FROM dual;
674:
675: SELECT template_name
676: INTO l_template_name
677: FROM zpb_dc_objects

Line 1511: FROM dual;

1507:
1508: -- Create a meaningful item key for dev use--
1509: SELECT ZPB_DC_WF_PROCESSES_S.nextval
1510: INTO l_sequence
1511: FROM dual;
1512:
1513: IF (l_object_type = 'E') THEN
1514: l_submit_type := 'Submit Template';
1515: ELSE

Line 2507: FROM dual;

2503: AND obj.object_user_id = fnd.user_id;
2504:
2505: SELECT ZPB_DC_WF_PROCESSES_S.nextval
2506: INTO l_sequence
2507: FROM dual;
2508:
2509: l_substr_templ_name := substr(l_template_name,1,140);
2510: l_approval_type := 'Approve Worksheet';
2511: l_char_date := to_char(sysdate, 'MM/DD/YYYY-HH24-MI-SS');

Line 2697: FROM dual;

2693:
2694:
2695: SELECT ZPB_DC_WF_PROCESSES_S.nextval
2696: INTO l_item_key
2697: FROM dual;
2698:
2699: SELECT nvl(description,user_name)
2700: INTO l_approver_for_msg
2701: FROM fnd_user

Line 2718: FROM dual;

2714: WHERE user_id= p_approver_user_id;
2715:
2716: SELECT ZPB_DC_WF_PROCESSES_S.nextval
2717: INTO l_sequence
2718: FROM dual;
2719:
2720: l_substr_templ_name := substr(l_template_name,1,140);
2721: l_rejection_type := 'Reject Worksheet';
2722: l_char_date := to_char(sysdate, 'MM/DD/YYYY-HH24-MI-SS');