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 942: FROM ar_paying_relationships_v ar

938: AND hzca.party_id IN
939: (SELECT p_filter_id FROM dual
940: UNION
941: SELECT ar.related_party_id
942: FROM ar_paying_relationships_v ar
943: WHERE ar.party_id = p_filter_id
944: AND TRUNC(sysdate) BETWEEN
945: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
946: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1129: FROM ar_paying_relationships_v ar

1125: AND hzca.party_id IN
1126: (SELECT p_filter_id FROM dual
1127: UNION
1128: SELECT ar.related_party_id
1129: FROM ar_paying_relationships_v ar
1130: WHERE ar.party_id = p_filter_id
1131: AND TRUNC(sysdate) BETWEEN
1132: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1133: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1404: FROM ar_paying_relationships_v ar

1400: AND hzca.party_id IN
1401: (SELECT p_filter_id FROM dual
1402: UNION
1403: SELECT ar.related_party_id
1404: FROM ar_paying_relationships_v ar
1405: WHERE ar.party_id = p_filter_id
1406: AND TRUNC(sysdate) BETWEEN
1407: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1408: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1639: FROM ar_paying_relationships_v ar

1635: AND hzca.party_id IN
1636: (SELECT p_filter_id FROM dual
1637: UNION
1638: SELECT ar.related_party_id
1639: FROM ar_paying_relationships_v ar
1640: WHERE ar.party_id = p_filter_id
1641: AND TRUNC(sysdate) BETWEEN
1642: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1643: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1816: FROM ar_paying_relationships_v ar

1812: AND hzca.party_id IN
1813: (SELECT p_filter_id FROM dual
1814: UNION
1815: SELECT ar.related_party_id
1816: FROM ar_paying_relationships_v ar
1817: WHERE ar.party_id = p_filter_id
1818: AND TRUNC(sysdate) BETWEEN
1819: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1820: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 1906: FROM ar_paying_relationships_v ar

1902: AND hzca.party_id IN
1903: (SELECT p_filter_id FROM dual
1904: UNION
1905: SELECT ar.related_party_id
1906: FROM ar_paying_relationships_v ar
1907: WHERE ar.party_id = p_filter_id
1908: AND TRUNC(sysdate) BETWEEN
1909: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
1910: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 2969: FROM ar_paying_relationships_v ar

2965: and hzca.party_id IN
2966: (SELECT p_filter_id FROM dual
2967: UNION
2968: SELECT ar.related_party_id
2969: FROM ar_paying_relationships_v ar
2970: WHERE ar.party_id = p_filter_id
2971: AND TRUNC(sysdate) BETWEEN
2972: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
2973: TRUNC(NVL(ar.effective_end_date,sysdate)) )

Line 3003: FROM ar_paying_relationships_v ar

2999: (SELECT p_filter_id
3000: FROM dual
3001: UNION
3002: SELECT ar.related_party_id
3003: FROM ar_paying_relationships_v ar
3004: WHERE ar.party_id = p_filter_id
3005: AND TRUNC(sysdate) BETWEEN TRUNC(nvl(ar.effective_start_date, sysdate))
3006: AND TRUNC(nvl(ar.effective_end_date, sysdate)))
3007: AND aabl.aging_bucket_id = p_bucket_id

Line 3425: FROM ar_paying_relationships_v ar

3421: and hzca.party_id IN
3422: (SELECT :party_id FROM dual
3423: UNION
3424: SELECT ar.related_party_id
3425: FROM ar_paying_relationships_v ar
3426: WHERE ar.party_id = :party_id
3427: AND TRUNC(sysdate) BETWEEN
3428: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
3429: TRUNC(NVL(ar.effective_end_date,sysdate)) ) ' ;

Line 3633: FROM ar_paying_relationships_v ar

3629: AND hzca.party_id IN
3630: (SELECT :party_id FROM dual
3631: UNION
3632: SELECT ar.related_party_id
3633: FROM ar_paying_relationships_v ar
3634: WHERE ar.party_id = :party_id
3635: AND TRUNC(sysdate) BETWEEN
3636: TRUNC(NVL(ar.effective_start_date,sysdate)) AND
3637: TRUNC(NVL(ar.effective_end_date,sysdate)) ) ' ;