APPS.AR_BILLS_CREATION_LIB_PVT SQL Statements

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

Line: 103

	SELECT 	site_uses.SITE_USE_ID
	INTO	p_drawee_site_use_id
	FROM	hz_cust_site_uses site_uses,
		hz_cust_acct_sites acct_site
	WHERE  	acct_site.cust_account_id	=  p_drawee_id
	AND	acct_site.cust_acct_site_id	=  site_uses.cust_acct_site_id
	AND	site_uses.site_use_code		=  'DRAWEE'
	AND	site_uses.status		=  'A'
	AND	site_uses.primary_flag		=  'Y';

Line: 165

	SELECT 	acct_role.cust_account_role_id
	INTO	p_drawee_contact_id
	FROM	hz_cust_account_roles acct_role,
		hz_role_responsibility role_res,
		HZ_CUST_SITE_USES site_uses
	WHERE  	acct_role.cust_account_id	=  p_drawee_id
	AND	nvl(acct_role.status, 'I')	=  'A'
	AND	acct_role.cust_acct_site_id  =  site_uses.cust_acct_site_id
	AND	site_uses.site_use_id	=  p_drawee_site_use_id
	AND	acct_role.cust_account_role_id	=  role_res.cust_account_role_id
	AND	role_res.responsibility_type 	=  'BILL_TO'
	AND	role_res.primary_flag		=  'Y';

Line: 227

	SELECT 	default_printing_option
	INTO	p_printing_option
	FROM	RA_CUST_TRX_TYPES
	WHERE  	cust_trx_type_id	=  p_cust_trx_type_id;

Line: 305

  	SELECT 	payment_schedule_id
	INTO	p_payment_schedule_id
	FROM	ar_payment_schedules
	WHERE	customer_trx_id		=	p_customer_trx_id;

Line: 548

		SELECT 	SYSDATE
    		INTO 	p_trx_rec.term_due_date
    		FROM 	dual;

Line: 560

    		SELECT 	SYSDATE
    		INTO 	p_trx_rec.trx_date
    		FROM	dual;

Line: 718

 |    Default_Update_BR_Header			                                |
 |                                                                           	|
 | DESCRIPTION                                                              	|
 |    Defaults data in the BR Header during Update				|
 |										|
 +==============================================================================*/


PROCEDURE Default_Update_BR_Header ( p_trx_rec	IN OUT NOCOPY	ra_customer_trx%ROWTYPE)
IS

BEGIN

   	IF PG_DEBUG in ('Y', 'C') THEN
   	   arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header()+ ');

Line: 739

  	SELECT 	batch_source_id
	INTO	p_trx_rec.batch_source_id
	FROM	ra_customer_trx
	WHERE	customer_trx_id		=	p_trx_rec.customer_trx_id;

Line: 746

	   arp_util.debug('AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header()- ');

Line: 752

      	   	   arp_util.debug('Default_Update_BR_Header: ' || '>>>>> No Batch Source could be defaulted for the BR');

Line: 757

		   arp_util.debug('>>>>>>>>>> EXCEPTION : AR_BILLS_CREATION_LIB_PVT.Default_Update_BR_Header () ');

Line: 761

END Default_Update_BR_Header;

Line: 795

	SELECT	count(*)
	INTO	l_count
	FROM	RA_CUSTOMER_TRX_LINES
	WHERE	br_ref_payment_schedule_id	=	p_ps_rec.payment_schedule_id
	AND	customer_trx_id			=	p_trl_rec.customer_trx_id;

Line: 861

	SELECT 	customer_trx_line_id
	FROM	ra_customer_trx_lines
	WHERE	customer_trx_id = p_customer_trx_id;

Line: 878

		AR_BILLS_CREATION_PUB.delete_br_assignment (
		p_api_version 			=>  1.0			,
	        x_return_status 		=>  l_return_status	,
	        x_msg_count     		=>  l_msg_count		,
	        x_msg_data     	 		=>  l_msg_data		,
		p_customer_trx_line_id		=>  assignment_rec.customer_trx_line_id);