APPS.ZX_JG_EXTRACT_PKG dependencies on FND_CURRENCIES

Line 404: fnd_currencies curr

400: INTO l_func_precision,
401: l_func_min_account_unit,
402: l_sob_type
403: FROM gl_ledgers sob,
404: fnd_currencies curr
405: WHERE sob.ledger_id = p_trl_global_variables_rec.ledger_id
406: AND sob.currency_code = curr.currency_code;
407:
408: IF 'Y' = PG_DEBUG THEN

Line 1053: fnd_currencies curr

1049: '|| l_ar_distributions ||' adjlndist,
1050: '|| l_ar_distributions ||' adjtxdist,
1051: '|| l_ar_adjustments ||' adj,
1052: '|| l_ra_customer_trx ||' trx,
1053: fnd_currencies curr
1054: WHERE
1055: adj.adjustment_id = :c_trx_id AND
1056: adjlndist.source_table = ''ADJ'' AND
1057: adjlndist.source_type IN (''ADJ'', ''FINCHRG'') AND

Line 1084: fnd_currencies curr,

1080: '|| l_ar_distributions ||' adjlndist,
1081: '|| l_ar_distributions ||' adjtxdist,
1082: '|| l_ar_adjustments ||' adj,
1083: '|| l_ra_customer_trx ||' trx,
1084: fnd_currencies curr,
1085: xla_distribution_links lnk,
1086: xla_ae_headers aeh,
1087: xla_ae_lines ael,
1088: xla_acct_class_assgns acs,

Line 1133: fnd_currencies curr,

1129: '|| l_ar_distributions ||' adjlndist,
1130: '|| l_ar_distributions ||' adjtxdist,
1131: '|| l_ar_adjustments ||' adj,
1132: '|| l_ra_customer_trx ||' trx,
1133: fnd_currencies curr,
1134: xla_distribution_links lnk,
1135: xla_ae_headers aeh,
1136: xla_ae_lines ael,
1137: xla_acct_class_assgns acs,

Line 1181: fnd_currencies curr,

1177: '|| l_ar_distributions ||' d,
1178: xla_distribution_links lnk,
1179: xla_ae_headers aeh,
1180: xla_ae_lines ael,
1181: fnd_currencies curr,
1182: xla_acct_class_assgns acs,
1183: xla_assignment_defns_b asd
1184: WHERE
1185: cr.cash_receipt_id = :c_trx_id AND

Line 1223: fnd_currencies curr,

1219: '|| l_ar_distributions ||' d,
1220: xla_distribution_links lnk,
1221: xla_ae_headers aeh,
1222: xla_ae_lines ael,
1223: fnd_currencies curr,
1224: xla_acct_class_assgns acs,
1225: xla_assignment_defns_b asd
1226: WHERE
1227: cr.cash_receipt_id = :c_trx_id AND

Line 1259: fnd_currencies curr

1255: '|| l_ar_distributions ||' dtax,
1256: '|| l_ar_distributions ||' d,
1257: '|| l_ar_receivable_applications ||' ra,
1258: '|| l_ar_cash_receipts ||' cr,
1259: fnd_currencies curr
1260: WHERE
1261: cr.cash_receipt_id = :c_trx_id AND
1262: d.source_table = ''RA'' AND
1263: d.line_id = :c_trx_line_id AND

Line 1287: fnd_currencies curr,

1283: '|| l_ar_distributions ||' dtax,
1284: '|| l_ar_distributions ||' d,
1285: '|| l_ar_receivable_applications ||' ra,
1286: '|| l_ar_cash_receipts ||' cr,
1287: fnd_currencies curr,
1288: xla_distribution_links lnk,
1289: xla_ae_headers aeh,
1290: xla_ae_lines ael,
1291: xla_acct_class_assgns acs,