APPS.AR_BILLS_MAINTAIN_VAL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

C_MATURITY_DATE_UPDATED		CONSTANT VARCHAR2(30)	:=	'MATURITY_DATE_UPDATED';

Line: 31

C_SELECTED_REMITTANCE		CONSTANT VARCHAR2(30)	:=	'SELECTED_REMITTANCE';

Line: 32

C_DESELECTED_REMITTANCE		CONSTANT VARCHAR2(30)	:=	'DESELECTED_REMITTANCE';

Line: 52

C_SELECT_REMIT			CONSTANT VARCHAR2(30)	:=	'SELECT_REMIT';

Line: 53

C_DESELECT_REMIT		CONSTANT VARCHAR2(30)	:=	'DESELECT_REMIT';

Line: 69

C_DELETE			CONSTANT VARCHAR2(30)	:=	'DELETE';

Line: 106

    SELECT 	count(*)
	  INTO 	l_count
	  FROM 	ra_customer_trx trx
	 WHERE  customer_trx_id=p_customer_trx_id
	   AND  trx.bill_to_customer_id IN
	(
	   SELECT arel.related_cust_account_id
	     FROM hz_cust_acct_relate arel
	    WHERE arel.cust_account_id 	= 	p_drawee_id
          AND arel.bill_to_flag = 'Y'
        UNION
	   SELECT rel.related_cust_account_id
         FROM ar_paying_relationships_v rel,
              hz_cust_accounts acc
        WHERE rel.party_id = acc.party_id
          AND acc.cust_account_id = p_drawee_id
          AND p_br_trx_date BETWEEN effective_start_date
                               AND effective_end_date
     );

Line: 172

	SELECT 	bill_to_customer_id
	INTO 	l_bill_to_customer_id
	FROM 	ra_customer_trx
	WHERE  	customer_trx_id=p_customer_trx_id;

Line: 299

	SELECT 	br_ref_customer_trx_id, extended_amount, br_ref_payment_schedule_id
	FROM	ra_customer_trx_lines
	WHERE	customer_trx_id = p_trx_rec.customer_trx_id;

Line: 550

	SELECT 	br_ref_customer_trx_id
	FROM	ra_customer_trx_lines
	WHERE	customer_trx_id = p_customer_trx_id;

Line: 565

		SELECT  'Y'
		INTO	l_assignment_exists
		FROM	ra_customer_trx
		WHERE	customer_trx_id = assignment_rec.br_ref_customer_trx_id;

Line: 623

		SELECT 	'Y'
		INTO	l_batch_id_valid
		FROM 	ar_BATCHES
		WHERE	batch_id	=	p_batch_id;

Line: 673

	SELECT 	'Y'
	INTO	l_payment_schedule_id_valid
	FROM 	AR_PAYMENT_SCHEDULES
	WHERE	payment_schedule_id  =  p_payment_schedule_id;

Line: 723

		SELECT 	'Y'
		INTO	l_adjustment_activity_valid
		FROM 	AR_RECEIVABLES_TRX
		WHERE	receivables_trx_id	=	p_adjustment_activity_id
		AND	status			=	'A'
		AND	type			=	'ENDORSEMENT';

Line: 784

  	SELECT 	'Y'
     	INTO   	l_reversal_reason_valid
	FROM   	ar_lookups
     	WHERE  	lookup_type 	=  'CKAJST_REASON'
       	and  	enabled_flag 	=  'Y'
       	and  	lookup_code 	=  p_reversal_reason;

Line: 1119

 |    Validates the remittance batch date and gl_date, before selecting a BR 	|
 |    for the remittance batch							|
 |                                                                           	|
 +==============================================================================*/


PROCEDURE  Validate_Remittance_Dates  (	p_batch_rec	IN	ar_batches%ROWTYPE		,
					p_trh_rec	IN	ar_transaction_history%ROWTYPE	,
					p_trx_number	IN	ra_customer_trx.trx_number%TYPE	)

IS

BEGIN

	IF PG_DEBUG in ('Y', 'C') THEN
	   arp_util.debug('AR_BILLS_MAINTAIN_VAL_PVT.Validate_Remittance_Dates()+');

Line: 1141

	|  History Record of the BR selected		|
	+-----------------------------------------------*/

	IF  	trunc(p_batch_rec.batch_date) < p_trh_rec.trx_date
	THEN
		IF PG_DEBUG in ('Y', 'C') THEN
		   arp_util.debug('Validate_Remittance_Dates: ' || '>>>>>>>>>> The BR ' || p_trx_number || ' cannot be selected in this remittance batch');

Line: 1161

	| History Record of the BR selected		|
	+-----------------------------------------------*/

	IF  	trunc(p_batch_rec.gl_date) < nvl(p_trh_rec.gl_date, p_batch_rec.gl_date)
	THEN
		IF PG_DEBUG in ('Y', 'C') THEN
		   arp_util.debug('Validate_Remittance_Dates: ' || '>>>>>>>>>> The BR ' || p_trx_number || ' cannot be selected in this remittance batch');