APPS.CS_FETCH_ARTXN_INFO_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 58: ra_customer_trx_lines lines,

54: trx_amount,
55: trx_class,
56: trx_date
57: FROM ra_customer_trx trx,
58: ra_customer_trx_lines lines,
59: ra_cust_trx_types trtypes
60: WHERE lines.line_type='LINE'
61: AND lines.interface_line_attribute1=to_char(cur_record.contract_id)
62: AND lines.interface_line_attribute2=to_char(cur_record.cp_service_id)

Line 70: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line in ra_customer_trx_lines for Contract ID : ' ||

66:
67: EXCEPTION
68: WHEN NO_DATA_FOUND THEN
69: ret_status := ERROR;
70: FND_FILE.PUT_LINE(FND_FILE.LOG,'No line in ra_customer_trx_lines for Contract ID : ' ||
71: to_char(cur_record.contract_id));
72: FND_FILE.PUT_LINE(FND_FILE.LOG,'SErvice ID : ' ||
73: to_char(cur_record.cp_service_id));
74: FND_FILE.PUT_LINE(FND_FILE.LOG,'Contract_Billing ID : ' ||

Line 85: FROM ra_customer_trx_lines

81: ELSE
82: BEGIN
83: SELECT extended_amount
84: INTO tax_amount
85: FROM ra_customer_trx_lines
86: WHERE line_type='TAX'
87: AND interface_line_attribute1=to_char(cur_record.contract_id)
88: AND interface_line_attribute2=to_char(cur_record.cp_service_id)
89: AND interface_line_attribute4=to_char(cur_record.contract_billing_id);