DBA Data[Home] [Help]

APPS.XLE_ASSOC_VALIDATIONS_PVT dependencies on XLE_ENTITY_PROFILES

Line 806: FROM XLE_ENTITY_PROFILES le1,

802: BEGIN
803:
804: SELECT le2.name, le1.transacting_entity_flag, le2.transacting_entity_flag
805: INTO le2_name, le1_transacting, le2_transacting
806: FROM XLE_ENTITY_PROFILES le1,
807: XLE_ENTITY_PROFILES le2
808: WHERE le1.legal_entity_id = p_subject_id
809: AND le2.legal_entity_id = p_object_id;
810:

Line 807: XLE_ENTITY_PROFILES le2

803:
804: SELECT le2.name, le1.transacting_entity_flag, le2.transacting_entity_flag
805: INTO le2_name, le1_transacting, le2_transacting
806: FROM XLE_ENTITY_PROFILES le1,
807: XLE_ENTITY_PROFILES le2
808: WHERE le1.legal_entity_id = p_subject_id
809: AND le2.legal_entity_id = p_object_id;
810:
811: IF (le1_transacting <> 'Y' AND le2_transacting <> 'Y') THEN