[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT trunc(g.start_date) start_date,
trunc(g.end_date) end_date
FROM gl_period_statuses g,
gl_sets_of_books b
WHERE g.application_id = 222
AND g.set_of_books_id = l_set_of_books_id
AND g.set_of_books_id = b.set_of_books_id
AND g.period_type = b.accounted_period_type
AND g.adjustment_period_flag = 'N'
AND g.closing_status IN ('O','F') ;
SELECT set_of_books_id
INTO l_set_of_books_id
FROM ar_system_parameters ;
SELECT lookup_code
FROM ar_lookups
WHERE lookup_type = 'APPROVAL_TYPE'
AND enabled_flag = 'Y'
AND sysdate BETWEEN nvl(start_date_active,sysdate)
AND nvl(end_date_active,sysdate) ;
SELECT lookup_code
FROM ar_lookups
WHERE lookup_type = 'ADJUSTMENT_TYPE'
AND enabled_flag = 'Y'
AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
trunc(sysdate))
AND nvl(trunc(end_date_active),trunc(sysdate)) ;
SELECT lookup_code
FROM ar_lookups
WHERE lookup_type = 'ADJUST_REASON'
AND enabled_flag = 'Y'
AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
trunc(sysdate))
AND nvl(trunc(end_date_active),trunc(sysdate)) ;
SELECT receivables_trx_id,name,code_combination_id
FROM ar_receivables_trx
WHERE nvl(status,'A') = 'A'
AND type in ('ADJUST','ENDORSEMENT')
AND receivables_trx_id not in ( -1,-11,-12,-13 )
AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
trunc(sysdate))
AND nvl(trunc(end_date_active),trunc(sysdate)) ;
SELECT ussgl_transaction_code,context
FROM gl_ussgl_transaction_codes
WHERE chart_of_accounts_id = arp_global.chart_of_accounts_id
AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
trunc(sysdate))
AND nvl(trunc(end_date_active),trunc(sysdate)) ;
SELECT code_combination_id
FROM gl_code_combinations
WHERE chart_of_accounts_id = arp_global.chart_of_accounts_id
AND enabled_flag = 'Y'
AND trunc(sysdate) BETWEEN nvl(trunc(start_date_active),
trunc(sysdate))
AND nvl(trunc(end_date_active),trunc(sysdate)) ;
G_APPROVAL_TBL.DELETE;
G_REASON_TBL.DELETE;
G_ADJTYPE_TBL.DELETE;
G_RCVTRX_TBL.DELETE;
G_USSGL_TBL.DELETE;
G_GLPERIOD_TBL.DELETE;
G_CCID_TBL.DELETE;
SELECT amount_to,
amount_from
INTO l_approval_amount_to,
l_approval_amount_from
FROM ar_approval_user_limits
WHERE user_id = l_user_id
AND currency_code = p_inv_curr_code;
| Ensure that approval data has been selected |
+-----------------------------------------------*/
IF ( p_approved_flag = FND_API.G_TRUE )
THEN
/*--------------------------------------------+
| Perform actual check of approval limits. |
+--------------------------------------------*/
IF (( p_adj_amount > l_approval_amount_to ) OR
( p_adj_amount < l_approval_amount_from ))
THEN
IF PG_DEBUG in ('Y', 'C') THEN
arp_util.debug('Within_approval_limits: ' || 'User ID: ' || l_user_id ||
' Amount: ' || p_adj_amount ||
' From: ' || l_approval_amount_from ||
' To: ' || l_approval_amount_to ||
' exceeds approval limit', G_MSG_HIGH );
SELECT *
INTO p_ps_rec
FROM ar_payment_schedules
WHERE payment_schedule_id = p_adj_rec.payment_schedule_id;
SELECT count(*)
INTO l_count
FROM RA_CUSTOMER_TRX_LINES
WHERE customer_trx_id = p_adj_rec.customer_trx_id AND
customer_trx_line_id = p_adj_rec.customer_trx_line_id ;
select invoice_currency_code into l_currency_code
from ra_customer_trx
where customer_trx_id=p_adj_rec.customer_trx_id;
SELECT count(*)
INTO l_count
FROM gl_code_combinations
WHERE code_combination_id = p_adj_rec.code_combination_id
AND enabled_flag = 'Y'
AND SYSDATE BETWEEN NVL(start_date_active, sysdate)
AND NVL(end_date_active, sysdate);
select set_of_books_id
into l_set_of_books_id
from ar_system_parameters;
SELECT count(*)
INTO l_count
FROM gl_period_statuses g,
gl_sets_of_books b
WHERE g.application_id = 222
AND g.set_of_books_id = l_set_of_books_id
AND g.set_of_books_id = b.set_of_books_id
AND g.period_type = b.accounted_period_type
AND g.adjustment_period_flag = 'N'
AND g.closing_status IN ('O','F')
AND trunc(p_gl_date) BETWEEN nvl(trunc(g.start_date),
trunc(p_gl_date))
AND nvl(trunc(g.end_date),trunc(p_gl_date)) ;
SELECT descriptive_flexfield_name
INTO l_flex_name
FROM fnd_descriptive_flexs
WHERE application_id = arp_global.G_AR_APP_ID AND
application_table_name like 'AR_ADJUSTMENTS' ;
SELECT count(*)
INTO l_count
FROM ar_cash_receipts
WHERE cash_receipt_id = p_adj_rec.associated_cash_receipt_id ;