APPS.IEX_COLL_IND dependencies on ARPCURR

Line 1111: SELECT SUM(arpcurr.functional_amount(

1107: l_temp_start := p_start_date;
1108: end if;
1109:
1110: IF p_party_id IS NOT NULL THEN
1111: SELECT SUM(arpcurr.functional_amount(
1112: ps.amount_due_original,
1113: g_curr_rec.base_currency,
1114: nvl(ps.exchange_rate,1),
1115: g_curr_rec.base_precision,

Line 1127: SELECT SUM(arpcurr.functional_amount(

1123: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
1124: AND ps.customer_id = ca.cust_account_id
1125: AND ca.party_id = p_party_id;
1126: ELSIF p_cust_account_id IS NOT NULL THEN
1127: SELECT SUM(arpcurr.functional_amount(
1128: ps.amount_due_original,
1129: g_curr_rec.base_currency,
1130: nvl(ps.exchange_rate,1),
1131: g_curr_rec.base_precision,

Line 1141: SELECT SUM(arpcurr.functional_amount(

1137: AND ps.payment_schedule_id <> -1
1138: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
1139: AND ps.customer_id = p_cust_account_id;
1140: ELSIF p_customer_site_use_id IS NOT NULL THEN
1141: SELECT SUM(arpcurr.functional_amount(
1142: ps.amount_due_original,
1143: g_curr_rec.base_currency,
1144: nvl(ps.exchange_rate,1),
1145: g_curr_rec.base_precision,