APPS.FUN_XML_REPORT_PKG dependencies on FUN_NET_AGREEMENTS_ALL

Line 143: FUN_NET_AGREEMENTS_ALL FNA

139: -- Bug: 8342465
140: SELECT FNA.ALLOW_DISC_FLAG, fna.net_currency_rule_code
141: INTO l_allow_disc_flag, l_net_currency_rule_code
142: FROM FUN_NET_BATCHES_ALL FNB,
143: FUN_NET_AGREEMENTS_ALL FNA
144: WHERE FNA.AGREEMENT_ID = FNB.AGREEMENT_ID
145: AND FNB.BATCH_ID = p_batch_id;
146:
147: select tag INTO l_encoding from fnd_lookup_values

Line 180: FUN_NET_AGREEMENTS_ALL FNA,

176: FNB.TRANSACTION_DUE_DATE,
177: FNB.RESPONSE_DATE,
178: LTRIM(TO_CHAR(FNB.TOTAL_NETTED_AMT,''999999999999999999999.999999999999'')) AS TOTAL_NETTED_AMT
179: FROM FUN_NET_BATCHES_ALL FNB,
180: FUN_NET_AGREEMENTS_ALL FNA,
181: HR_OPERATING_UNITS HOU,
182: CE_BANK_ACCOUNTS CBA,
183: FUN_LOOKUPS FLC1,
184: FUN_LOOKUPS FLC2,

Line 521: FUN_NET_AGREEMENTS_ALL FNA

517: -- Bug: 8342465
518: SELECT FNA.ALLOW_DISC_FLAG, fna.net_currency_rule_code
519: INTO l_allow_disc_flag, l_net_currency_rule_code
520: FROM FUN_NET_BATCHES_ALL FNB,
521: FUN_NET_AGREEMENTS_ALL FNA
522: WHERE FNA.AGREEMENT_ID = FNB.AGREEMENT_ID
523: AND FNB.BATCH_ID = p_batch_id;
524:
525: select tag INTO l_encoding from fnd_lookup_values

Line 560: FUN_NET_AGREEMENTS_ALL FNA,

556: FNB.TRANSACTION_DUE_DATE,
557: FNB.RESPONSE_DATE,
558: LTRIM(TO_CHAR(FNB.TOTAL_NETTED_AMT,''999999999999999999999.999999999999'')) AS TOTAL_NETTED_AMT
559: FROM FUN_NET_BATCHES_ALL FNB,
560: FUN_NET_AGREEMENTS_ALL FNA,
561: HR_OPERATING_UNITS HOU,
562: CE_BANK_ACCOUNTS CBA,
563: FUN_LOOKUPS FLC1,
564: FUN_LOOKUPS FLC2,