APPS.IEX_COLL_IND dependencies on ARPCURR

Line 1000: SELECT SUM(arpcurr.functional_amount(

996: l_temp_start := p_start_date;
997: end if;
998:
999: IF p_party_id IS NOT NULL THEN
1000: SELECT SUM(arpcurr.functional_amount(
1001: ps.amount_due_original,
1002: g_curr_rec.base_currency,
1003: nvl(ps.exchange_rate,1),
1004: g_curr_rec.base_precision,

Line 1016: SELECT SUM(arpcurr.functional_amount(

1012: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
1013: AND ps.customer_id = ca.cust_account_id
1014: AND ca.party_id = p_party_id;
1015: ELSIF p_cust_account_id IS NOT NULL THEN
1016: SELECT SUM(arpcurr.functional_amount(
1017: ps.amount_due_original,
1018: g_curr_rec.base_currency,
1019: nvl(ps.exchange_rate,1),
1020: g_curr_rec.base_precision,

Line 1030: SELECT SUM(arpcurr.functional_amount(

1026: AND ps.payment_schedule_id <> -1
1027: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
1028: AND ps.customer_id = p_cust_account_id;
1029: ELSIF p_customer_site_use_id IS NOT NULL THEN
1030: SELECT SUM(arpcurr.functional_amount(
1031: ps.amount_due_original,
1032: g_curr_rec.base_currency,
1033: nvl(ps.exchange_rate,1),
1034: g_curr_rec.base_precision,