APPS.IEX_PROFILE dependencies on AR_PAYING_RELATIONSHIPS_V

Line 59: FROM ar_paying_relationships_v ar

55: and hzca.party_id IN
56: (SELECT p_filter_id FROM dual
57: UNION
58: SELECT ar.related_party_id
59: FROM ar_paying_relationships_v ar
60: WHERE ar.party_id = p_filter_id
61: AND TRUNC(sysdate) BETWEEN
62: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
63: TRUNC(NVL(ar.effective_end_date,sysdate)) );

Line 348: -- FROM ar_paying_relationships_v ar

344: -- AND JII.Party_Id IN
345: -- (SELECT p_party_id FROM dual
346: -- UNION
347: -- SELECT ar.related_party_id
348: -- FROM ar_paying_relationships_v ar
349: -- WHERE ar.party_id = p_party_id
350: -- AND TRUNC(sysdate) BETWEEN
351: -- TRUNC(NVL(ar.effective_start_date,sysdate)) AND
352: -- TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 375: FROM ar_paying_relationships_v ar

371: AND JII.Party_Id IN
372: (SELECT p_party_id FROM dual
373: UNION
374: SELECT ar.related_party_id
375: FROM ar_paying_relationships_v ar
376: WHERE ar.party_id = p_party_id
377: AND TRUNC(sysdate) BETWEEN
378: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
379: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 585: FROM ar_paying_relationships_v ar

581: AND HZCA.Party_id IN
582: (SELECT p_party_id FROM dual
583: UNION
584: SELECT ar.related_party_id
585: FROM ar_paying_relationships_v ar
586: WHERE ar.party_id = p_party_id
587: AND TRUNC(sysdate) BETWEEN
588: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
589: TRUNC(NVL(ar.effective_end_date,sysdate)) );