DBA Data[Home] [Help]

APPS.OKC_DELIVERABLE_WF_PVT dependencies on OKC_RESP_PARTIES_TL

Line 392: FROM okc_resp_parties_tl

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
393: WHERE RESP_PARTY_CODE = p_resp_party
394: AND language = userenv('LANG');
395:
396: l_resp_party_name okc_resp_parties_tl.name%TYPE;

Line 396: l_resp_party_name okc_resp_parties_tl.name%TYPE;

392: FROM okc_resp_parties_tl
393: WHERE RESP_PARTY_CODE = p_resp_party
394: AND language = userenv('LANG');
395:
396: l_resp_party_name okc_resp_parties_tl.name%TYPE;
397:
398: CURSOR c_contact_name(p_contact IN varchar2) IS
399: SELECT full_name
400: FROM PER_ALL_PEOPLE_F

Line 1521: l_resp_party okc_resp_parties_tl.name%TYPE;

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:
1525: l_firstcolon NUMBER;