APPS.OKC_DELIVERABLE_WF_PVT dependencies on OKC_DELIVERABLE_TYPES_TL

Line 383: FROM okc_deliverable_types_tl oktl, okc_deliverables okd

379: where party_id=p_external_contact;*/
380:
381: CURSOR c_del_type(p_del_id IN NUMBER) IS
382: SELECT name
383: FROM okc_deliverable_types_tl oktl, okc_deliverables okd
384: WHERE oktl.deliverable_type_code =okd.DELIVERABLE_TYPE
385: AND okd.deliverable_id=p_del_id
386: AND oktl.language = userenv('LANG') ;
387:

Line 388: l_del_type_name okc_deliverable_types_tl.name%TYPE;

384: WHERE oktl.deliverable_type_code =okd.DELIVERABLE_TYPE
385: AND okd.deliverable_id=p_del_id
386: AND oktl.language = userenv('LANG') ;
387:
388: l_del_type_name okc_deliverable_types_tl.name%TYPE;
389:
390: CURSOR c_resp_party_name(p_resp_party IN VARCHAR2) IS
391: SELECT name
392: FROM okc_resp_parties_tl

Line 1520: l_del_type okc_deliverable_types_tl.name%TYPE;

1516: l_msgbody VARCHAR2(32000);
1517:
1518: l_bus_doc_type okc_deliverables.business_document_type%TYPE;
1519: l_del_name okc_deliverables.deliverable_name%TYPE;
1520: l_del_type okc_deliverable_types_tl.name%TYPE;
1521: l_resp_party okc_resp_parties_tl.name%TYPE;
1522: l_int_contact_name per_all_people_f.full_name%TYPE;
1523: l_ext_contact_name per_all_people_f.full_name%TYPE;
1524: