APPS.FUN_WEBADI_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 332: l_le_party_id Xle_Firstparty_Information_V.party_id%type;

328: l_insert Varchar2(1);
329:
330: -- 24-10-2007 MAKANSAL
331: -- For Bug # 6249898 Introduced to keep the recipient party id and recipient legal entity id
332: l_le_party_id Xle_Firstparty_Information_V.party_id%type;
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

Line 339: From Xle_Firstparty_Information_V

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
342: l_batch_rec.batch_id := p_batch_rec.batch_id;
343: l_batch_rec.batch_number := p_batch_rec.batch_number;

Line 662: From Xle_Firstparty_Information_V

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:
665: Cursor C_Le_Name (cp_party_id In Xle_Entity_Profiles.party_id%type) Is
666: Select name

Line 667: 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:
670: Cursor C_Trx_Type (cp_trx_type_name In Fun_Interface_Batches.trx_type_name%type) Is
671: Select trx_type_code, trx_type_id, allow_invoicing_flag

Line 718: xle_firstparty_information_v xfi ,

714:
715: Cursor C_Ccid(cp_party_name In Fun_Interface_Batches.initiator_name%type) Is
716: Select chart_of_accounts_id
717: From Hz_Parties hzp,
718: xle_firstparty_information_v xfi ,
719: Gl_Ledger_Le_V led
720: Where hzp.party_name = cp_party_name
721: And fun_tca_pkg.get_le_id(hzp.party_id) = xfi.party_id
722: And xfi.legal_entity_id = led.legal_entity_id

Line 745: l_le_party_id Xle_Firstparty_Information_V.party_id%type;

741: And party_type_flag = cp_party_type_flag;
742:
743: l_count Number;
744: l_batch_insert Varchar2(1);
745: l_le_party_id Xle_Firstparty_Information_V.party_id%type;
746: l_from_le_name Fun_Interface_Batches.from_le_name%type;
747: l_reci_name Fun_Interface_Headers.recipient_name%type;
748: l_trx_insert Varchar2(1);
749: l_dup_reci_count Number;