APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on WF_NOTIFICATIONS

Line 6130: SELECT ITEM_KEY FROM wf_notifications WHERE ITEM_KEY LIKE Concat(chld_item_key,'\_%') ESCAPE '\'

6126: FROM okc_rep_contracts_all
6127: WHERE contract_id = p_contract_id;
6128:
6129: CURSOR csr_child_notification(chld_item_key VARCHAR2) IS
6130: SELECT ITEM_KEY FROM wf_notifications WHERE ITEM_KEY LIKE Concat(chld_item_key,'\_%') ESCAPE '\'
6131: AND STATUS='OPEN';
6132:
6133:
6134: BEGIN