DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKL_CS_PROCESS_TMPLTS_UV

Line 1064: FROM okl_cs_process_tmplts_uv

1060: resultout out nocopy varchar2)
1061: AS
1062: CURSOR c_document(p_ptm_code IN VARCHAR2) IS
1063: SELECT jtf_amv_item_id,email_subject_line
1064: FROM okl_cs_process_tmplts_uv
1065: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
1066: AND start_date <= TRUNC(sysdate)
1067: AND NVL(end_date, sysdate) >= TRUNC(sysdate)
1068: AND ptm_code = p_ptm_code;

Line 1186: FROM okl_cs_process_tmplts_uv

1182: resultout out nocopy varchar2)
1183: AS
1184: CURSOR c_document(p_ptm_code IN VARCHAR2) IS
1185: SELECT jtf_amv_item_id,email_subject_line
1186: FROM okl_cs_process_tmplts_uv
1187: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
1188: AND start_date <= TRUNC(sysdate)
1189: AND NVL(end_date, sysdate) >= TRUNC(sysdate)
1190: AND ptm_code = p_ptm_code;