DBA Data[Home] [Help]

APPS.FUN_WEBADI_PKG dependencies on XLE_ENTITY_PROFILES

Line 337: Cursor C_Le_Id(cp_le_party_id In Xle_Entity_Profiles.party_id%type) Is

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

Line 660: Cursor C_Le_Id(cp_le_party_id In Xle_Entity_Profiles.party_id%type) Is

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:

Line 665: Cursor C_Le_Name (cp_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:
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: