333: l_to_le_id GL_LEDGER_LE_BSV_SPECIFIC_V.LEGAL_ENTITY_ID%type;
334:
335: -- 24-10-2007 MAKANSAL
336: -- For Bug # 6249898 Introduced the Cursor to fetch the Recipient Legal Entity Id
337: Cursor C_Le_Id(cp_le_party_id In Xle_Entity_Profiles.party_id%type) Is
338: Select legal_entity_id
339: From Xle_Firstparty_Information_V
340: Where party_id = cp_le_party_id;
341: Begin
656: And hu.party_usage_code = 'INTERCOMPANY_ORG';
657:
658: --Bug No: 6134848 ends here
659:
660: Cursor C_Le_Id(cp_le_party_id In Xle_Entity_Profiles.party_id%type) Is
661: Select legal_entity_id
662: From Xle_Firstparty_Information_V
663: Where party_id = cp_le_party_id;
664:
661: Select legal_entity_id
662: From Xle_Firstparty_Information_V
663: Where party_id = cp_le_party_id;
664:
665: Cursor C_Le_Name (cp_party_id In Xle_Entity_Profiles.party_id%type) Is
666: Select name
667: From xle_firstparty_information_v
668: Where party_id = cp_party_id;
669: