APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on RA_TERMS_VL

Line 4617: l_term_name ra_terms_vl.NAME%TYPE;

4613: l_memo_line_start_date ar_memo_lines.start_date%TYPE;
4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;
4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;
4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;
4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;
4620: l_organization_name hr_operating_units.NAME%TYPE;
4621: l_ra_batch_source_id NUMBER(15);

Line 4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;

4614: l_memo_line_end_date ar_memo_lines.end_date%TYPE;
4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;
4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;
4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;
4620: l_organization_name hr_operating_units.NAME%TYPE;
4621: l_ra_batch_source_id NUMBER(15);
4622:

Line 4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;

4615: l_memo_line_rev_acc ar_memo_lines.gl_id_rev%TYPE;
4616:
4617: l_term_name ra_terms_vl.NAME%TYPE;
4618: l_term_start_date ra_terms_vl.START_DATE_ACTIVE%TYPE;
4619: l_term_end_Date ra_terms_vl.END_DATE_ACTIVE%TYPE;
4620: l_organization_name hr_operating_units.NAME%TYPE;
4621: l_ra_batch_source_id NUMBER(15);
4622:
4623: BEGIN

Line 5107: FROM ra_terms_vl rt

5103: rt.END_DATE_ACTIVE
5104: INTO l_term_name,
5105: l_term_start_date,
5106: l_term_end_Date
5107: FROM ra_terms_vl rt
5108: WHERE 1 = (SELECT Count(*)
5109: FROM ra_terms_lines rtl
5110: WHERE rtl.term_id = rt.term_id
5111: AND rtl.relative_amount = rt.base_amount

Line 5671: FROM ra_terms_vl rt

5667:
5668: /* Insert Payment Term Name also */
5669:
5670: SELECT rt.NAME INTO l_term_name
5671: FROM ra_terms_vl rt
5672: WHERE rt.term_id = p_in_rec.payment_term_id;
5673:
5674: BEGIN
5675: INSERT INTO ra_interface_lines_all