APPS.ARP_GROUP_INV dependencies on AR_CONS_INV_TRX

Line 82: l_group_inv_line_number AR_CONS_INV_TRX.cons_inv_line_number%TYPE:=1;

78: new_cons_inv_id AR_PAYMENT_SCHEDULES.CONS_INV_ID%TYPE:=-1;
79:
80: old_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
81: new_cons_billing_number AR_CONS_INV.CONS_BILLING_NUMBER%TYPE:='$$~$$';
82: l_group_inv_line_number AR_CONS_INV_TRX.cons_inv_line_number%TYPE:=1;
83:
84: BEGIN
85:
86: arp_standard.debug('arp_group_inv.generate()+');

Line 107: FROM ar_cons_inv_trx

103:
104: /* bug3886862 */
105: SELECT nvl(max(cons_inv_line_number),0) + 1
106: INTO l_group_inv_line_number
107: FROM ar_cons_inv_trx
108: WHERE cons_inv_id = new_cons_inv_id ;
109:
110: /* if there is no cons inv with the id, create new record */
111: IF l_group_inv_line_number = 1 THEN

Line 156: INSERT INTO ar_cons_inv_trx

152: END IF;
153:
154: END IF; /** New group ***/
155:
156: INSERT INTO ar_cons_inv_trx
157: (cons_inv_id,
158: transaction_type,
159: trx_number,
160: transaction_date,