APPS.IEX_AGING_BUCKETS_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 875: ra_cust_trx_line_gl_dist gld

871: SELECT NVL( SUM( DECODE(p_currency_code, NULL,
872: ps.acctd_amount_due_remaining,
873: ps.amount_due_remaining)), 0)
874: FROM ar_payment_schedules ps,
875: ra_cust_trx_line_gl_dist gld
876: WHERE ps.customer_id = p_filter_id
877: AND decode(p_customer_site_use_id,
878: NULL, ps.customer_site_use_id,
879: p_customer_site_use_id) = ps.customer_site_use_id

Line 895: ra_cust_trx_line_gl_dist gld

891: SELECT NVL( SUM( DECODE(p_currency_code, NULL,
892: ps.acctd_amount_due_remaining,
893: ps.amount_due_remaining)), 0)
894: FROM ar_payment_schedules ps,
895: ra_cust_trx_line_gl_dist gld
896: WHERE ps.customer_site_use_id = p_filter_id
897: AND decode(upper(p_currency_code),
898: NULL, ps.invoice_currency_code,
899: upper(p_currency_code)) = ps.invoice_currency_code

Line 913: ra_cust_trx_line_gl_dist gld,

909: SELECT NVL( SUM( DECODE(p_currency_code, NULL,
910: ps.acctd_amount_due_remaining,
911: ps.amount_due_remaining)), 0)
912: FROM ar_payment_schedules ps,
913: ra_cust_trx_line_gl_dist gld,
914: hz_cust_accounts hzca
915: WHERE ps.customer_id = hzca.cust_account_id
916: AND hzca.party_id = p_filter_id
917: AND decode(p_customer_site_use_id,

Line 935: ra_cust_trx_line_gl_dist gld,

931: SELECT NVL( SUM( DECODE(p_currency_code, NULL,
932: ps.acctd_amount_due_remaining,
933: ps.amount_due_remaining)), 0)
934: FROM ar_payment_schedules ps,
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