56: and hzca.party_id IN
57: (SELECT p_filter_id FROM dual
58: UNION
59: SELECT ar.related_party_id
60: FROM ar_paying_relationships_v ar
61: WHERE ar.party_id = p_filter_id
62: AND TRUNC(sysdate) BETWEEN
63: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
64: TRUNC(NVL(ar.effective_end_date,sysdate)) );
416: -- AND JII.Party_Id IN
417: -- (SELECT p_party_id FROM dual
418: -- UNION
419: -- SELECT ar.related_party_id
420: -- FROM ar_paying_relationships_v ar
421: -- WHERE ar.party_id = p_party_id
422: -- AND TRUNC(sysdate) BETWEEN
423: -- TRUNC(NVL(ar.effective_start_date,sysdate)) AND
424: -- TRUNC(NVL(ar.effective_end_date,sysdate)) )
443: AND JII.Party_Id IN
444: (SELECT p_party_id FROM dual
445: UNION
446: SELECT ar.related_party_id
447: FROM ar_paying_relationships_v ar
448: WHERE ar.party_id = p_party_id
449: AND TRUNC(sysdate) BETWEEN
450: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
451: TRUNC(NVL(ar.effective_end_date,sysdate)) )
699: AND HZCA.Party_id IN
700: (SELECT p_party_id FROM dual
701: UNION
702: SELECT ar.related_party_id
703: FROM ar_paying_relationships_v ar
704: WHERE ar.party_id = p_party_id
705: AND TRUNC(sysdate) BETWEEN
706: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
707: TRUNC(NVL(ar.effective_end_date,sysdate)) );