DBA Data[Home] [Help]

APPS.HR_ABSUTIL_SS dependencies on FND_ATTACHED_DOCUMENTS

Line 566: lv_pkey1 fnd_attached_documents.pk1_value%type;

562: c_proc constant varchar2(30) := 'hasSupportingDocuments';
563: lv_item_type wf_item_activity_statuses.item_type%type;
564: lv_item_key wf_item_activity_statuses.item_key%type;
565: lv_entity_name constant varchar2(50) := 'PER_ABSENCE_ATTENDANCES';
566: lv_pkey1 fnd_attached_documents.pk1_value%type;
567: l_exists VARCHAR2(1);
568:
569: begin
570: g_debug := hr_utility.debug_enabled;

Line 584: from fnd_attached_documents

580:
581: begin
582: SELECT 'Y'
583: INTO l_exists
584: from fnd_attached_documents
585: where entity_name=lv_entity_name
586: and pk1_value=lv_pkey1
587: AND ROWNUM = 1;
588: exception