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 663: From Xle_Firstparty_Information_V

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

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

Line 719: xle_firstparty_information_v xfi ,

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

Line 746: l_le_party_id Xle_Firstparty_Information_V.party_id%type;

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