APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_THIRD_PARTIES_V

Line 333: FROM XLA_THIRD_PARTIES_V

329: -- Validate the passed original third party
330: BEGIN
331: SELECT 'X'
332: INTO v_dummy
333: FROM XLA_THIRD_PARTIES_V
334: WHERE THIRD_PARTY_ID = p_original_third_party_id
335: AND THIRD_PARTY_TYPE = p_third_party_type;
336: EXCEPTION
337: WHEN NO_DATA_FOUND THEN

Line 352: FROM XLA_THIRD_PARTIES_V

348: -- Validate the passed new third party
349: BEGIN
350: SELECT 'X'
351: INTO v_dummy
352: FROM XLA_THIRD_PARTIES_V
353: WHERE THIRD_PARTY_ID = p_new_third_party_id
354: AND THIRD_PARTY_TYPE = p_third_party_type;
355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN

Line 5173: xla_third_parties_v p1,

5169: ent.entity_id,
5170: ent.source_application_id,
5171: ent.ledger_id
5172: FROM xla_events evt,
5173: xla_third_parties_v p1,
5174: xla_third_parties_v p2,
5175: xla_third_party_sites_v s1,
5176: xla_third_party_sites_v s2,
5177: xla_transaction_entities ent,

Line 5174: xla_third_parties_v p2,

5170: ent.source_application_id,
5171: ent.ledger_id
5172: FROM xla_events evt,
5173: xla_third_parties_v p1,
5174: xla_third_parties_v p2,
5175: xla_third_party_sites_v s1,
5176: xla_third_party_sites_v s2,
5177: xla_transaction_entities ent,
5178: xla_ledger_options lgopt,

Line 5252: v_original_party_number xla_third_parties_v.third_party_number%TYPE;

5248: v_old_site_id NUMBER(15);
5249: v_new_party_id NUMBER(15);
5250: v_new_site_id NUMBER(15);
5251: -- v_original_desc_token VARCHAR2(1000);
5252: v_original_party_number xla_third_parties_v.third_party_number%TYPE;
5253: v_original_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5254: -- v_new_desc_token VARCHAR2(1000);
5255: v_new_party_number xla_third_parties_v.third_party_number%TYPE;
5256: v_new_site_code xla_third_party_sites_v.third_party_site_code%TYPE;

Line 5255: v_new_party_number xla_third_parties_v.third_party_number%TYPE;

5251: -- v_original_desc_token VARCHAR2(1000);
5252: v_original_party_number xla_third_parties_v.third_party_number%TYPE;
5253: v_original_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5254: -- v_new_desc_token VARCHAR2(1000);
5255: v_new_party_number xla_third_parties_v.third_party_number%TYPE;
5256: v_new_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5257: v_party_type VARCHAR2(1);
5258: v_mapping_flag VARCHAR2(1);
5259: v_entity_id NUMBER(15);