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 661: Cursor C_Le_Id(cp_le_party_id In Xle_Entity_Profiles.party_id%type) Is

657: And hu.party_usage_code = 'INTERCOMPANY_ORG';
658:
659: --Bug No: 6134848 ends here
660:
661: Cursor C_Le_Id(cp_le_party_id In Xle_Entity_Profiles.party_id%type) Is
662: Select legal_entity_id
663: From Xle_Firstparty_Information_V
664: Where party_id = cp_le_party_id;
665:

Line 666: Cursor C_Le_Name (cp_party_id In Xle_Entity_Profiles.party_id%type) Is

662: Select legal_entity_id
663: From Xle_Firstparty_Information_V
664: Where party_id = cp_le_party_id;
665:
666: Cursor C_Le_Name (cp_party_id In Xle_Entity_Profiles.party_id%type) Is
667: Select name
668: From xle_firstparty_information_v
669: Where party_id = cp_party_id;
670: