APPS.AR_AGING_BUCKETS_PKG dependencies on AR_AGING_PAYMENT_SCHEDULES

Line 1279: FROM ar_aging_payment_schedules

1275: arp_standard.debug( 'pg_retain_staging_flag :'||pg_retain_staging_flag );
1276: END IF;
1277:
1278: DELETE
1279: FROM ar_aging_payment_schedules
1280: WHERE parent_request_id = pg_request_id;
1281:
1282: DELETE
1283: FROM ar_aging_extract

Line 1390: 'INSERT /*HINT*/ INTO ar_aging_payment_schedules a

1386: END IF;
1387: END IF;
1388:
1389: l_insert_stmt :=
1390: 'INSERT /*HINT*/ INTO ar_aging_payment_schedules a
1391: ( payment_schedule_id,
1392: source_type,
1393: parent_request_id,
1394: worker_id

Line 1626: -- FROM ar_aging_payment_schedules aging,

1622: -- ps.org_id,
1623: -- ps.invoice_currency_code,
1624: -- nvl(ps.exchange_rate, 1) exchange_rate,
1625: -- ps.cons_inv_id
1626: -- FROM ar_aging_payment_schedules aging,
1627: -- ar_payment_schedules ps,
1628: -- ra_customer_trx ct,
1629: -- ar_adjustments adj
1630: -- WHERE aging.parent_request_id = :parent_request_id

Line 2137: FROM ar_aging_payment_schedules aging,

2133: ps.org_id,
2134: ps.invoice_currency_code,
2135: nvl(ps.exchange_rate,1) exchange_rate,
2136: 0 cons_inv_id
2137: FROM ar_aging_payment_schedules aging,
2138: ar_payment_schedules ps,
2139: ar_adjustments adj
2140: WHERE aging.parent_request_id = :parent_request_id
2141: AND aging.worker_id = :worker_id

Line 2208: FROM ar_aging_payment_schedules aging,

2204: ps.org_id,
2205: ps.invoice_currency_code,
2206: nvl(ps.exchange_rate, 1) exchange_rate,
2207: 0 cons_inv_id
2208: FROM ar_aging_payment_schedules aging,
2209: ar_payment_schedules ps,
2210: ar_receivable_applications app
2211: WHERE aging.parent_request_id = :parent_request_id
2212: AND aging.worker_id = :worker_id

Line 2266: FROM ar_aging_payment_schedules aging,

2262: ps.org_id,
2263: ps.invoice_currency_code,
2264: nvl(ps.exchange_rate, 1) exchange_rate,
2265: ps.cons_inv_id
2266: FROM ar_aging_payment_schedules aging,
2267: ar_payment_schedules ps,
2268: ra_customer_trx ct
2269: WHERE aging.parent_request_id = :parent_request_id
2270: AND aging.worker_id = :worker_id

Line 2441: ar_aging_payment_schedules aging,

2437: '''|| pg_payment_meaning ||''' sort_field2,
2438: '''|| pg_payment_meaning ||''' invoice_type '|| l_rep_specific_cols ||'
2439: from hz_cust_accounts cust_acct,
2440: hz_parties party,
2441: ar_aging_payment_schedules aging,
2442: ar_payment_schedules ps,
2443: hz_cust_site_uses site,
2444: hz_cust_acct_sites acct_site,
2445: hz_party_sites party_site,

Line 2552: ar_aging_payment_schedules aging,

2548: '''|| pg_risk_meaning ||''' sort_field2,
2549: '''|| pg_risk_meaning ||''' invoice_type '|| l_rep_specific_cols ||'
2550: from hz_cust_accounts cust_acct,
2551: hz_parties party,
2552: ar_aging_payment_schedules aging,
2553: ar_payment_schedules ps,
2554: hz_cust_site_uses site,
2555: hz_cust_acct_sites acct_site,
2556: hz_party_sites party_site,

Line 2662: ar_aging_payment_schedules aging,

2658: arpt_sql_func_util.get_org_trx_type_details(ps.cust_trx_type_id,ps.org_id) invoice_type
2659: '|| l_rep_specific_cols ||'
2660: from hz_cust_accounts cust_acct,
2661: hz_parties party,
2662: ar_aging_payment_schedules aging,
2663: ar_payment_schedules ps,
2664: hz_cust_site_uses site,
2665: hz_cust_acct_sites acct_site,
2666: hz_party_sites party_site,