DBA Data[Home] [Help]

APPS.PO_XML_DELIVERY dependencies on PER_ALL_PEOPLE_F

Line 892: select full_name into p_requestor from PER_ALL_PEOPLE_F where

888: and pda.po_line_id = p_line_id
889: and pda.revision_num = p_revision_num;
890:
891: if(l_agent_id is not null) then
892: select full_name into p_requestor from PER_ALL_PEOPLE_F where
893: person_id = l_agent_id and
894: effective_end_date >= sysdate;
895:
896: end if;

Line 914: select full_name into p_requestor from PER_ALL_PEOPLE_F where

910: and pda.revision_num = p_revision_num
911: and pda.po_release_id = p_release_num;
912:
913: if(l_agent_id is not null) then
914: select full_name into p_requestor from PER_ALL_PEOPLE_F where
915: person_id = l_agent_id and
916: effective_end_date >= sysdate;
917:
918: end if;