DBA Data[Home] [Help]

APPS.HR_PERSON_DEPLOYMENT_API dependencies on FND_ATTACHED_DOCUMENTS

Line 970: from fnd_attached_documents

966: -- fix for bug 6593649
967: l_attachments varchar2(1);
968: cursor csr_get_attached_doc is
969: select null
970: from fnd_attached_documents
971: where PK1_VALUE =p_person_deployment_id
972: and ENTITY_NAME ='HR_PERSON_DEPLOYMENTS';
973: --
974: -- fix for bug 6593649

Line 2084: update fnd_attached_documents

2080: if csr_get_attached_doc%found then
2081: close csr_get_attached_doc;
2082: hr_utility.set_location(l_host_person_id,200);
2083:
2084: update fnd_attached_documents
2085: set ENTITY_NAME='PER_PEOPLE_F' ,PK1_VALUE =l_host_person_id
2086: WHERE PK1_VALUE=p_person_deployment_id
2087: and ENTITY_NAME ='HR_PERSON_DEPLOYMENTS' ;
2088: