DBA Data[Home] [Help]

APPS.ARP_PA_UTILS dependencies on ARPCURR

Line 92: , NVL(SUM(arpcurr.currround((line_applied * acctd_amount_applied_to)/

88:
89: BEGIN
90: SELECT
91: NVL(SUM(NVL(line_applied,0) ), 0)
92: , NVL(SUM(arpcurr.currround((line_applied * acctd_amount_applied_to)/
93: amount_applied )), 0)
94: , NVL(SUM(DECODE(SIGN(acctd_amount_applied_from -
95: acctd_amount_applied_to),
96: 1,

Line 97: arpcurr.currround(((acctd_amount_applied_from -

93: amount_applied )), 0)
94: , NVL(SUM(DECODE(SIGN(acctd_amount_applied_from -
95: acctd_amount_applied_to),
96: 1,
97: arpcurr.currround(((acctd_amount_applied_from -
98: acctd_amount_applied_to) *
99: line_applied)/amount_applied),0)), 0)
100: , NVL(SUM(DECODE(SIGN(acctd_amount_applied_from -
101: acctd_amount_applied_to),

Line 103: arpcurr.currround(((acctd_amount_applied_from -

99: line_applied)/amount_applied),0)), 0)
100: , NVL(SUM(DECODE(SIGN(acctd_amount_applied_from -
101: acctd_amount_applied_to),
102: -1,
103: arpcurr.currround(((acctd_amount_applied_from -
104: acctd_amount_applied_to) * -1 *
105: line_applied)/amount_applied),0)),
106: 0)
107: INTO l_amount_applied

Line 187: , NVL(SUM(arpcurr.currround((app.line_applied * amr.acctd_amount_applied_to)/

183: THEN
184: BEGIN
185: SELECT amr.set_of_books_id
186: , NVL(SUM(NVL(app.line_applied,0) ), 0)
187: , NVL(SUM(arpcurr.currround((app.line_applied * amr.acctd_amount_applied_to)/
188: app.amount_applied )), 0)
189: , NVL(SUM(DECODE(SIGN(amr.acctd_amount_applied_from -
190: amr.acctd_amount_applied_to),
191: 1,