DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on ARPT_SQL_FUNC_UTIL

Line 2161: ARPT_SQL_FUNC_UTIL.Get_Number_Of_Due_Dates(ps.term_id) number_of_installments,

2157: ps.DUE_DATE,
2158: ps.PAYMENT_SCHEDULE_ID,
2159: ps.STATUS,
2160: trm.name term_desc,
2161: ARPT_SQL_FUNC_UTIL.Get_Number_Of_Due_Dates(ps.term_id) number_of_installments,
2162: ps.terms_sequence_number,
2163: ps.amount_line_items_original line_amount,
2164: ps.tax_original tax_amount,
2165: ps.freight_original freight_amount,

Line 2433: ARPT_SQL_FUNC_UTIL.Get_Number_Of_Due_Dates(ps.term_id) number_of_installments,

2429: ps.DUE_DATE,
2430: ps.PAYMENT_SCHEDULE_ID,
2431: ps.STATUS,
2432: trm.name term_desc,
2433: ARPT_SQL_FUNC_UTIL.Get_Number_Of_Due_Dates(ps.term_id) number_of_installments,
2434: ps.terms_sequence_number,
2435: ps.amount_line_items_original line_amount,
2436: ps.tax_original tax_amount,
2437: ps.freight_original freight_amount,

Line 5122: ARPT_SQL_FUNC_UTIL.Get_Number_Of_Due_Dates(ps.term_id) number_of_installments,

5118: 0,
5119: DECODE(ps.class, 'PMT', l_amount_due_remaining, 'CM', l_amount_due_remaining,
5120: ARI_UTILITIES.curr_round_amt(l_amount_due_remaining-l_discount_amount -l_dispute_amount,ps.INVOICE_CURRENCY_CODE)),
5121: trm.name term_desc,
5122: ARPT_SQL_FUNC_UTIL.Get_Number_Of_Due_Dates(ps.term_id) number_of_installments,
5123: ps.terms_sequence_number,
5124: ps.amount_line_items_original line_amount,
5125: ps.tax_original tax_amount,
5126: ps.freight_original freight_amount,