APPS.JL_BR_AP_VALIDATE_COLLECTION SQL Statements

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

Line: 46

   Select etb.establishment_name compname
         ,etb.registration_number
         ,etb.legal_entity_id
   From
          xle_establishment_v etb
         ,xle_bsv_associations bsv
         ,gl_ledger_le_v gl
   Where
         etb.legal_entity_id = gl.legal_entity_id
   And   bsv.legal_parent_id = etb.legal_entity_id
   And   etb.establishment_id = bsv.legal_construct_id
   And   bsv.entity_name = e_accounting_balancing_segment
   And   gl.ledger_id = e_set_of_books_id;

Line: 67

   	SELECT currency_code
   	INTO s_currency_code
   	FROM FND_CURRENCIES_VL
   	WHERE substr(global_attribute1,1,15) = e_cnab_currency_code;

Line: 83

   	SELECT 'Y'
   	INTO x_aux
   	FROM sys.dual
   	WHERE EXISTS (
   		SELECT null
   		FROM FND_LOOKUPS
   		WHERE lookup_type = 'JLBR_ARREARS_CODE'
   		AND   lookup_code = e_arrears_code );

Line: 135

     SELECT '1'
     INTO x_register_type
     FROM fnd_lookups
     WHERE lookup_code = e_drawee_inscription_type
     AND lookup_type   = 'JLBR_INSCRIPTION_TYPE'
     AND NVL(end_date_active,sysdate + 1) > sysdate;

Line: 154

   	SELECT branch_party_id
   	INTO x_bank_branch_id
   	FROM ce_bank_branches_v
   	WHERE bank_number = e_drawee_bank_code
	AND branch_number = e_drawee_branch_code
        AND country = 'BR';

Line: 173

   	SELECT 'Y'
   	INTO x_aux
   	FROM sys.dual
   	WHERE EXISTS (
   		SELECT null
   		FROM ce_bank_accounts
   		WHERE bank_branch_id = x_bank_branch_id
   		AND   bank_account_num = e_drawee_account );

Line: 193

   		SELECT 	povs.vendor_site_id,
   			substr(pov.vendor_name,1,240)
   		INTO	s_vendor_site_id,
   			x_vendor_name
   		FROM	po_vendor_sites povs,
   			po_vendors	pov
   		WHERE	povs.global_attribute9 = e_transf_inscription_type
   		AND	povs.global_attribute10 = substr(e_transf_inscription_number,4,9)
   		AND	povs.global_attribute12 = substr(e_transf_inscription_number,13,2)
   		AND	pov.vendor_id = povs.vendor_id;

Line: 207

   		SELECT 	povs.vendor_site_id,
   			substr(pov.vendor_name,1,240)
   		INTO	s_vendor_site_id,
   			x_vendor_name
   		FROM	po_vendor_sites povs,
   			po_vendors	pov
   		WHERE	povs.global_attribute9 = e_transf_inscription_type
   		AND	povs.global_attribute10 = '0'||substr(e_transf_inscription_number,1,8)
   		AND	povs.global_attribute11 = substr(e_transf_inscription_number,9,4)
   		AND	povs.global_attribute12 = substr(e_transf_inscription_number,13,2)
   		AND	pov.vendor_id = povs.vendor_id;

Line: 243

   	SELECT 'Y'
   	INTO x_aux
   	FROM sys.dual
   	WHERE EXISTS (
   		SELECT null
   		FROM ce_bank_branches_v
   		WHERE bank_number = e_transferor_bank_code
   		AND   branch_number = e_transferor_branch_code
                AND   country = 'BR' );

Line: 262

	SELECT (decode(e_arrears_code,NULL,0,1)+
		decode(e_arrears_date,NULL,0,1)+
            	abs(nvl(e_arrears_interest,0))),
	       (decode(e_arrears_code,NULL,0,1)*
		decode(e_arrears_date,NULL,0,1)*
            	nvl(e_arrears_interest,0))
	INTO x_aux1,x_aux2
	FROM sys.dual;