APPS.IEX_AGING_BUCKETS_PKG dependencies on AR_PAYING_RELATIONSHIPS_V

Line 30: FROM ar_paying_relationships_v ar

26: WHERE party_id IN
27: (SELECT p_party FROM dual
28: UNION
29: SELECT ar.related_party_id
30: FROM ar_paying_relationships_v ar
31: WHERE ar.party_id = p_party
32: AND TRUNC(sysdate) BETWEEN
33: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
34: TRUNC(NVL(ar.effective_end_date,sysdate)));

Line 922: FROM ar_paying_relationships_v ar

918: AND hzca.party_id IN
919: (SELECT p_filter_id FROM dual
920: UNION
921: SELECT ar.related_party_id
922: FROM ar_paying_relationships_v ar
923: WHERE ar.party_id = p_filter_id
924: AND TRUNC(sysdate) BETWEEN
925: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
926: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1109: FROM ar_paying_relationships_v ar

1105: AND hzca.party_id IN
1106: (SELECT p_filter_id FROM dual
1107: UNION
1108: SELECT ar.related_party_id
1109: FROM ar_paying_relationships_v ar
1110: WHERE ar.party_id = p_filter_id
1111: AND TRUNC(sysdate) BETWEEN
1112: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1113: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1384: FROM ar_paying_relationships_v ar

1380: AND hzca.party_id IN
1381: (SELECT p_filter_id FROM dual
1382: UNION
1383: SELECT ar.related_party_id
1384: FROM ar_paying_relationships_v ar
1385: WHERE ar.party_id = p_filter_id
1386: AND TRUNC(sysdate) BETWEEN
1387: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1388: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1619: FROM ar_paying_relationships_v ar

1615: AND hzca.party_id IN
1616: (SELECT p_filter_id FROM dual
1617: UNION
1618: SELECT ar.related_party_id
1619: FROM ar_paying_relationships_v ar
1620: WHERE ar.party_id = p_filter_id
1621: AND TRUNC(sysdate) BETWEEN
1622: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1623: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1796: FROM ar_paying_relationships_v ar

1792: AND hzca.party_id IN
1793: (SELECT p_filter_id FROM dual
1794: UNION
1795: SELECT ar.related_party_id
1796: FROM ar_paying_relationships_v ar
1797: WHERE ar.party_id = p_filter_id
1798: AND TRUNC(sysdate) BETWEEN
1799: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1800: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1886: FROM ar_paying_relationships_v ar

1882: AND hzca.party_id IN
1883: (SELECT p_filter_id FROM dual
1884: UNION
1885: SELECT ar.related_party_id
1886: FROM ar_paying_relationships_v ar
1887: WHERE ar.party_id = p_filter_id
1888: AND TRUNC(sysdate) BETWEEN
1889: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1890: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 2949: FROM ar_paying_relationships_v ar

2945: and hzca.party_id IN
2946: (SELECT p_filter_id FROM dual
2947: UNION
2948: SELECT ar.related_party_id
2949: FROM ar_paying_relationships_v ar
2950: WHERE ar.party_id = p_filter_id
2951: AND TRUNC(sysdate) BETWEEN
2952: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
2953: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 2983: FROM ar_paying_relationships_v ar

2979: (SELECT p_filter_id
2980: FROM dual
2981: UNION
2982: SELECT ar.related_party_id
2983: FROM ar_paying_relationships_v ar
2984: WHERE ar.party_id = p_filter_id
2985: AND TRUNC(sysdate) BETWEEN TRUNC(nvl(ar.effective_start_date, sysdate))
2986: AND TRUNC(nvl(ar.effective_end_date, sysdate)))
2987: AND aabl.aging_bucket_id = p_bucket_id

Line 3390: FROM ar_paying_relationships_v ar

3386: and hzca.party_id IN
3387: (SELECT :party_id FROM dual
3388: UNION
3389: SELECT ar.related_party_id
3390: FROM ar_paying_relationships_v ar
3391: WHERE ar.party_id = :party_id
3392: AND TRUNC(sysdate) BETWEEN
3393: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
3394: TRUNC(NVL(ar.effective_end_date,sysdate)) ) ' ;

Line 3598: FROM ar_paying_relationships_v ar

3594: AND hzca.party_id IN
3595: (SELECT :party_id FROM dual
3596: UNION
3597: SELECT ar.related_party_id
3598: FROM ar_paying_relationships_v ar
3599: WHERE ar.party_id = :party_id
3600: AND TRUNC(sysdate) BETWEEN
3601: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
3602: TRUNC(NVL(ar.effective_end_date,sysdate)) ) ' ;