APPS.AR_DEFERRAL_REASONS_GRP dependencies on RA_CUSTOMER_TRX_LINES

Line 110: FROM ra_customer_trx_lines

106: l_rows NUMBER;
107: l_target_in_ar BOOLEAN := FALSE;
108: CURSOR parent_lines IS
109: SELECT customer_trx_line_id, customer_trx_id
110: FROM ra_customer_trx_lines
111: WHERE interface_line_context = p_order_line.interface_line_context
112: AND interface_line_attribute1 = p_order_line.interface_line_attribute1
113: AND interface_line_attribute2 = p_order_line.interface_line_attribute2
114: AND interface_line_attribute3 = p_order_line.interface_line_attribute3

Line 121: FROM ra_customer_trx_lines pline,

117: AND interface_line_attribute6 = p_order_line.interface_line_attribute6;
118:
119: CURSOR child_lines(parent_trx_line_id NUMBER) IS
120: SELECT child.customer_trx_line_id, child.customer_trx_id
121: FROM ra_customer_trx_lines pline,
122: ar_deferred_lines child
123: WHERE pline.customer_trx_line_id = parent_trx_line_id
124: AND pline.interface_line_context = g_om_context
125: AND child.parent_line_id = to_number(pline.interface_line_attribute6);

Line 358: FROM ra_customer_trx_lines

354: AND wda.delivery_id = p_delivery_id;
355:
356: CURSOR lines (p_order_line line_flex_rec) IS
357: SELECT customer_trx_line_id, customer_trx_id
358: FROM ra_customer_trx_lines
359: WHERE interface_line_context = p_order_line.interface_line_context
360: AND interface_line_attribute1 = p_order_line.interface_line_attribute1
361: AND interface_line_attribute1 = p_order_line.interface_line_attribute2
362: AND interface_line_attribute1 = p_order_line.interface_line_attribute3