APPS.OKC_DELIVERABLE_WF_PVT dependencies on PER_ALL_PEOPLE_F

Line 400: FROM PER_ALL_PEOPLE_F

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
401: WHERE person_id=p_contact ;
402:
403: l_ext_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
404: l_int_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;

Line 403: l_ext_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;

399: SELECT full_name
400: FROM PER_ALL_PEOPLE_F
401: WHERE person_id=p_contact ;
402:
403: l_ext_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
404: l_int_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
405:
406: l_int_role_display_name wf_roles.display_name%TYPE;
407: l_req_role_display_name wf_roles.display_name%TYPE;

Line 404: l_int_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;

400: FROM PER_ALL_PEOPLE_F
401: WHERE person_id=p_contact ;
402:
403: l_ext_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
404: l_int_contact_name PER_ALL_PEOPLE_F.full_name%TYPE;
405:
406: l_int_role_display_name wf_roles.display_name%TYPE;
407: l_req_role_display_name wf_roles.display_name%TYPE;
408: l_ext_role_display_name wf_roles.display_name%TYPE;

Line 1522: l_int_contact_name per_all_people_f.full_name%TYPE;

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;
1526: l_secondcolon NUMBER;

Line 1523: l_ext_contact_name per_all_people_f.full_name%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;
1526: l_secondcolon NUMBER;
1527: l_thirdcolon NUMBER;