DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKL_CS_PROCESS_TMPLTS_UV

Line 1055: FROM okl_cs_process_tmplts_uv

1051: resultout out nocopy varchar2)
1052: AS
1053: CURSOR c_document(p_ptm_code IN VARCHAR2) IS
1054: SELECT jtf_amv_item_id,email_subject_line
1055: FROM okl_cs_process_tmplts_uv
1056: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
1057: AND start_date <= TRUNC(sysdate)
1058: AND NVL(end_date, sysdate) >= TRUNC(sysdate)
1059: AND ptm_code = p_ptm_code;

Line 1177: FROM okl_cs_process_tmplts_uv

1173: resultout out nocopy varchar2)
1174: AS
1175: CURSOR c_document(p_ptm_code IN VARCHAR2) IS
1176: SELECT jtf_amv_item_id,email_subject_line
1177: FROM okl_cs_process_tmplts_uv
1178: WHERE NVL(org_id, -99) = NVL(mo_global.get_current_org_id(), -99)
1179: AND start_date <= TRUNC(sysdate)
1180: AND NVL(end_date, sysdate) >= TRUNC(sysdate)
1181: AND ptm_code = p_ptm_code;