APPS.IEX_AGING_BUCKETS_PKG dependencies on DUAL

Line 27: (SELECT p_party FROM dual

23: IS
24: SELECT cust_account_id
25: FROM HZ_CUST_ACCOUNTS
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

Line 939: (SELECT p_filter_id FROM dual

935: ra_cust_trx_line_gl_dist gld,
936: hz_cust_accounts hzca
937: WHERE ps.customer_id = hzca.cust_account_id
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

Line 1126: (SELECT p_filter_id FROM dual

1122: ar_payment_schedules ps,
1123: hz_cust_accounts hzca
1124: WHERE ps.customer_id = hzca.cust_account_id
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

Line 1401: (SELECT p_filter_id FROM dual

1397: ar_cash_receipt_history crh,
1398: hz_cust_accounts hzca
1399: WHERE cr.pay_from_customer = hzca.cust_account_id
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

Line 1636: (SELECT p_filter_id FROM dual

1632: FROM ar_payment_schedules ps,
1633: hz_cust_accounts hzca
1634: WHERE ps.customer_id = hzca.cust_Account_id
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

Line 1813: (SELECT p_filter_id FROM dual

1809: FROM ar_payment_schedules ps,
1810: hz_cust_accounts hzca
1811: WHERE ps.customer_id = hzca.cust_account_id
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

Line 1903: (SELECT p_filter_id FROM dual

1899: FROM ar_payment_schedules ps,
1900: hz_cust_accounts hzca
1901: WHERE ps.customer_id = hzca.cust_account_id
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

Line 2279: from dual ;

2275: -- Sysdate-1 is passed to follow AR API aging calculation.
2276: -- Modified by Surya on 02/03/03. Bug # 2754557
2277: Select TRUNC(sysdate)
2278: into l_date
2279: from dual ;
2280:
2281:
2282: -- IF PG_DEBUG < 10 THEN
2283: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2966: (SELECT p_filter_id FROM dual

2962: and trunc(sysdate)-aps.due_date >= aabl.days_start
2963: and trunc(sysdate)-aps.due_date <= aabl.days_to
2964: and id.cust_account_id = hzca.cust_account_id
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

Line 3000: FROM dual

2996: AND TRUNC(sysdate) -aps.due_date <= aabl.days_to
2997: AND id.cust_account_id = hzca.cust_account_id
2998: AND hzca.party_id IN
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

Line 3422: (SELECT :party_id FROM dual

3418: and arp.status = ''OP''
3419: and arp.customer_id = hzca.cust_account_id
3420: and aabl.aging_bucket_line_id = :bucket_line_id
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

Line 3630: (SELECT :party_id FROM dual

3626: and arp.status = :l_status
3627: and aabl.aging_bucket_line_id = :bucket_line_id
3628: AND arp.customer_id = hzca.cust_account_id
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