DBA Data[Home] [Help]

APPS.PSP_ER_WORKFLOW dependencies on PSP_WF_ITEM_KEY_S

Line 218: psp_wf_item_key_s.nextval

214: from psp_report_templates_h where request_id = p_request_id;
215:
216: cursor wf_item_key_cur(p_request_id integer) is
217: select wf_role_name,
218: psp_wf_item_key_s.nextval
219: from (select era.wf_role_name
220: from psp_eff_report_approvals era,
221: psp_eff_reports er,
222: psp_eff_report_details erd

Line 1811: select psp_wf_item_key_s.nextval

1807: OPEN payroll_action_id_cur;
1808: FETCH payroll_action_id_cur INTO l_payroll_action_id;
1809: CLOSE payroll_action_id_cur;
1810:
1811: select psp_wf_item_key_s.nextval
1812: into l_wf_itemkey
1813: from dual;
1814:
1815: OPEN template_name_cur;