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 919: (SELECT p_filter_id FROM dual

915: ra_cust_trx_line_gl_dist gld,
916: hz_cust_accounts hzca
917: WHERE ps.customer_id = hzca.cust_account_id
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

Line 1106: (SELECT p_filter_id FROM dual

1102: ar_payment_schedules ps,
1103: hz_cust_accounts hzca
1104: WHERE ps.customer_id = hzca.cust_account_id
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

Line 1381: (SELECT p_filter_id FROM dual

1377: ar_cash_receipt_history crh,
1378: hz_cust_accounts hzca
1379: WHERE cr.pay_from_customer = hzca.cust_account_id
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

Line 1616: (SELECT p_filter_id FROM dual

1612: FROM ar_payment_schedules ps,
1613: hz_cust_accounts hzca
1614: WHERE ps.customer_id = hzca.cust_Account_id
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

Line 1793: (SELECT p_filter_id FROM dual

1789: FROM ar_payment_schedules ps,
1790: hz_cust_accounts hzca
1791: WHERE ps.customer_id = hzca.cust_account_id
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

Line 1883: (SELECT p_filter_id FROM dual

1879: FROM ar_payment_schedules ps,
1880: hz_cust_accounts hzca
1881: WHERE ps.customer_id = hzca.cust_account_id
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

Line 2259: from dual ;

2255: -- Sysdate-1 is passed to follow AR API aging calculation.
2256: -- Modified by Surya on 02/03/03. Bug # 2754557
2257: Select TRUNC(sysdate)
2258: into l_date
2259: from dual ;
2260:
2261:
2262: -- IF PG_DEBUG < 10 THEN
2263: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2946: (SELECT p_filter_id FROM dual

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

Line 2980: FROM dual

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

Line 3387: (SELECT :party_id FROM dual

3383: and arp.status = ''OP''
3384: and arp.customer_id = hzca.cust_account_id
3385: and aabl.aging_bucket_line_id = :bucket_line_id
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

Line 3595: (SELECT :party_id FROM dual

3591: and arp.status = :l_status
3592: and aabl.aging_bucket_line_id = :bucket_line_id
3593: AND arp.customer_id = hzca.cust_account_id
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