APPS.JAI_AR_VALIDATE_DATA_PKG dependencies on RA_TERMS

Line 140: p_first_installment_code OUT NOCOPY ra_terms.first_installment_code%TYPE,

136: PROCEDURE calc_term_apportion_ratio(p_invoice_type IN ar_payment_schedules_all.class%TYPE,
137: p_term_id IN ar_payment_schedules_all.term_id%TYPE,
138: p_terms_sequence_number IN ar_payment_schedules_all.terms_sequence_number%TYPE,
139: p_apportion_ratio OUT NOCOPY NUMBER,
140: p_first_installment_code OUT NOCOPY ra_terms.first_installment_code%TYPE,
141: p_process_status OUT NOCOPY VARCHAR2,
142: p_process_message OUT NOCOPY VARCHAR2
143: )
144: IS

Line 150: FROM ra_terms rt ,

146: CURSOR cur_get_ra_term_ratio
147: IS
148: SELECT rtl.relative_amount/rt.base_amount apportion_ratio,
149: rt.first_installment_code
150: FROM ra_terms rt ,
151: ra_terms_lines rtl
152: WHERE rt.term_id = rtl.term_id
153: AND rtl.term_id = p_term_id
154: AND rtl.sequence_num = p_terms_sequence_number;

Line 151: ra_terms_lines rtl

147: IS
148: SELECT rtl.relative_amount/rt.base_amount apportion_ratio,
149: rt.first_installment_code
150: FROM ra_terms rt ,
151: ra_terms_lines rtl
152: WHERE rt.term_id = rtl.term_id
153: AND rtl.term_id = p_term_id
154: AND rtl.sequence_num = p_terms_sequence_number;
155:

Line 193: lv_first_installment_code RA_TERMS.FIRST_INSTALLMENT_CODE%TYPE;

189: p_process_status OUT NOCOPY VARCHAR2,
190: p_process_message OUT NOCOPY VARCHAR2)
191: IS
192: ln_apportion_ratio NUMBER ;
193: lv_first_installment_code RA_TERMS.FIRST_INSTALLMENT_CODE%TYPE;
194: lv_process_status VARCHAR2(2);
195: lv_process_message VARCHAR2(2000);
196: lv_sql_statement VARCHAR2(4000);
197:

Line 315: lv_first_installment_code RA_TERMS.FIRST_INSTALLMENT_CODE%TYPE;

311: p_process_status OUT NOCOPY VARCHAR2,
312: p_process_message OUT NOCOPY VARCHAR2)
313: IS
314: ln_apportion_ratio NUMBER;
315: lv_first_installment_code RA_TERMS.FIRST_INSTALLMENT_CODE%TYPE;
316: lv_process_status VARCHAR2(2);
317: lv_process_message VARCHAR2(2000);
318: lv_sql_statement VARCHAR2(4000);
319: