APPS.PQH_DOCUMENTS_SWI dependencies on PQH_DOCUMENT_ATTRIBUTES_F

Line 294: from pqh_document_attributes_f

290: --
291: --
292: Cursor csr_child_records_4_zap IS
293: Select document_attribute_id , object_version_number ,effective_start_date
294: from pqh_document_attributes_f
295: where document_id =p_document_id
296: and effective_start_date > p_effective_date
297: and document_attribute_id NOT IN (select document_attribute_id
298: from pqh_document_attributes_f

Line 298: from pqh_document_attributes_f

294: from pqh_document_attributes_f
295: where document_id =p_document_id
296: and effective_start_date > p_effective_date
297: and document_attribute_id NOT IN (select document_attribute_id
298: from pqh_document_attributes_f
299: where document_id =p_document_id
300: and p_effective_date between effective_start_date and effective_end_date);
301: --
302: --

Line 305: from pqh_document_attributes_f

301: --
302: --
303: Cursor csr_child_records_4_fut_del IS
304: Select document_attribute_id , object_version_number
305: from pqh_document_attributes_f
306: where document_id =p_document_id
307: and effective_start_date > p_effective_date
308: and document_attribute_id IN (select document_attribute_id
309: from pqh_document_attributes_f

Line 309: from pqh_document_attributes_f

305: from pqh_document_attributes_f
306: where document_id =p_document_id
307: and effective_start_date > p_effective_date
308: and document_attribute_id IN (select document_attribute_id
309: from pqh_document_attributes_f
310: where document_id =p_document_id
311: and p_effective_date between effective_start_date and effective_end_date);
312: --
313: --

Line 316: from pqh_document_attributes_f

312: --
313: --
314: Cursor csr_child_records_4_del IS
315: Select document_attribute_id, object_version_number,effective_start_date
316: from pqh_document_attributes_f
317: where document_id = p_document_id
318: and p_effective_date between effective_start_date and effective_end_date
319: and effective_end_date = hr_general.end_of_time;
320: