DBA Data[Home] [Help]

APPS.RA_LL_RCV_GROUPS_PKG dependencies on RA_CUSTOMER_TRX

Line 17: from ra_customer_trx

13: AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
14: AND GROUP_ID = X_GROUP_ID
15: AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- BUG 7241111
16: AND CUSTOMER_TRX_LINE_ID = (select customer_trx_line_id
17: from ra_customer_trx
18: where customer_trx_id = X_CUSTOMER_TRX_ID);
19:
20:
21: IF ( SQL%NOTFOUND ) THEN

Line 53: from ra_customer_trx_lines line,

49: line.amount_due_remaining line_rem,
50: line.amount_due_original line_orig,
51: tax.amount_due_remaining tax_rem,
52: tax.amount_due_original tax_orig
53: from ra_customer_trx_lines line,
54: (select link_to_cust_trx_line_id,
55: line_type,
56: sum(nvl(amount_due_original,0)) amount_due_original,
57: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 58: from ra_customer_trx_lines

54: (select link_to_cust_trx_line_id,
55: line_type,
56: sum(nvl(amount_due_original,0)) amount_due_original,
57: sum(nvl(amount_due_remaining,0)) amount_due_remaining
58: from ra_customer_trx_lines
59: where nvl(line_type,'TAX') = 'TAX'
60: group by link_to_cust_trx_line_id,
61: line_type
62: ) tax

Line 111: from ra_customer_trx_lines line,

107: sum(nvl(tax.amount_due_original,0))
108: into line_count,
109: all_linrem_tot, all_taxrem_tot,
110: all_linorig_tot, all_taxorig_tot
111: from ra_customer_trx_lines line,
112: (select link_to_cust_trx_line_id,
113: line_type,
114: sum(nvl(amount_due_original,0)) amount_due_original,
115: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 116: from ra_customer_trx_lines

112: (select link_to_cust_trx_line_id,
113: line_type,
114: sum(nvl(amount_due_original,0)) amount_due_original,
115: sum(nvl(amount_due_remaining,0)) amount_due_remaining
116: from ra_customer_trx_lines
117: where nvl(line_type,'TAX') = 'TAX'
118: group by link_to_cust_trx_line_id,
119: line_type
120: ) tax