DBA Data[Home] [Help]

APPS.EDR_PSIG dependencies on EDR_EVENT_RELATIONSHIP

Line 2771: from edr_event_relationship rel

2767: begin
2768:
2769: --Obtain the parent e-record ID.
2770: select rel.parent_erecord_id into l_parent_erecord_id
2771: from edr_event_relationship rel
2772: where child_erecord_id = p_document_id;
2773:
2774: --Obtain the e-record header details.
2775: l_current_xml := get_erecord_header_xml(p_document_id => l_parent_erecord_id);

Line 2923: from EDR_EVENT_RELATIONSHIP rel

2919:
2920:
2921: cursor get_child_erecord_ids_cur(p_document_id NUMBER) is
2922: select level,rel.CHILD_ERECORD_ID CHILD_ERECORD_ID
2923: from EDR_EVENT_RELATIONSHIP rel
2924: connect by prior CHILD_ERECORD_ID = PARENT_ERECORD_ID
2925: start with PARENT_ERECORD_ID = p_document_id and CHILD_ERECORD_ID <> p_document_id;
2926:
2927: