APPS.ARP_COLL_IND dependencies on ARPCURR

Line 139: SELECT SUM(arpcurr.functional_amount(

135: end if;
136:
137: if pcall_from = 222 then -- Called by AR responsibility
138:
139: SELECT SUM(arpcurr.functional_amount(
140: ps.amount_due_original,
141: curr_rec.base_currency,
142: nvl(ps.exchange_rate,1),
143: curr_rec.base_precision,

Line 158: -- SELECT clause modified by S.Bhattal to avoid calling package ARPCURR

154: (psite_id <> -1 AND ps.customer_site_use_id = psite_id));
155:
156: elsif pcall_from = 101 then -- Called by GL responsibility
157:
158: -- SELECT clause modified by S.Bhattal to avoid calling package ARPCURR
159: -- (so that we don't crash in ARPCURR's initialization section, which
160: -- refers to multi-org view AR_SYSTEM_PARAMETERS)
161:
162: SELECT SUM( gl_currency_api.convert_closest_amount_sql(

Line 159: -- (so that we don't crash in ARPCURR's initialization section, which

155:
156: elsif pcall_from = 101 then -- Called by GL responsibility
157:
158: -- SELECT clause modified by S.Bhattal to avoid calling package ARPCURR
159: -- (so that we don't crash in ARPCURR's initialization section, which
160: -- refers to multi-org view AR_SYSTEM_PARAMETERS)
161:
162: SELECT SUM( gl_currency_api.convert_closest_amount_sql(
163: ps.invoice_currency_code

Line 991: arpcurr.functional_amount(

987: above_amount
988: FROM (
989: SELECT
990: SUM(
991: arpcurr.functional_amount(
992: ps.amount_due_original,
993: curr_rec.base_currency,
994: nvl(ps.exchange_rate,1),
995: curr_rec.base_precision,

Line 1008: arpcurr.functional_amount(

1004: AND (pcust_id = -1 OR
1005: (pcust_id <> -1 AND ps.customer_id = pcust_id))
1006: GROUP BY ps.customer_trx_id
1007: HAVING SUM(
1008: arpcurr.functional_amount(
1009: ps.amount_due_original,
1010: curr_rec.base_currency,
1011: nvl(ps.exchange_rate,1),
1012: curr_rec.base_precision,

Line 1088: HAVING SUM(arpcurr.functional_amount(

1084: and ps.payment_schedule_id <> -1
1085: and (pcust_id = -1 OR
1086: (pcust_id <> -1 AND ps.customer_id = pcust_id))
1087: GROUP BY ps.customer_trx_id
1088: HAVING SUM(arpcurr.functional_amount(
1089: ps.amount_due_original,
1090: curr_rec.base_currency,
1091: nvl(ps.exchange_rate,1),
1092: curr_rec.base_precision,

Line 1156: arpcurr.functional_amount(

1152: below_amount
1153: FROM (
1154: SELECT
1155: SUM(
1156: arpcurr.functional_amount(
1157: ps.amount_due_original,
1158: curr_rec.base_currency,
1159: nvl(ps.exchange_rate,1),
1160: curr_rec.base_precision,

Line 1175: arpcurr.functional_amount(

1171: AND ( pcust_id = -1 OR
1172: (pcust_id <> -1 AND ps.customer_id = pcust_id))
1173: GROUP BY ps.customer_trx_id
1174: HAVING SUM(
1175: arpcurr.functional_amount(
1176: ps.amount_due_original,
1177: curr_rec.base_currency,
1178: nvl(ps.exchange_rate,1),
1179: curr_rec.base_precision,

Line 1253: arpcurr.functional_amount(

1249: and (pcust_id = -1 OR
1250: (pcust_id <> -1 AND ps.customer_id = pcust_id))
1251: GROUP BY ps.customer_trx_id
1252: HAVING SUM(
1253: arpcurr.functional_amount(
1254: ps.amount_due_original,
1255: curr_rec.base_currency,
1256: nvl(ps.exchange_rate,1),
1257: curr_rec.base_precision,