DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on AR_SYSTEM_PARAMETERS

Line 243: FROM AR_SYSTEM_PARAMETERS;

239: p_salesrep_id :=null;
240: begin
241: SELECT SALESREP_REQUIRED_FLAG,ORG_ID
242: into l_salesreprequiredflag,l_org_id
243: FROM AR_SYSTEM_PARAMETERS;
244:
245: exception
246: when no_data_found then
247: arp_util.debug(' profile not defined()- ');

Line 368: -- ar_system_parameters.salesrep_required_flag%type;

364: IF (l_return = -1 )
365: THEN
366:
367: /* To 'No Sales Credits' if Required_Flag='Y' */
368: -- ar_system_parameters.salesrep_required_flag%type;
369: IF ( l_salesreprequiredflag ='Y')
370: THEN
371: l_default_srep_id_3 := -3;
372:

Line 471: from ar_system_parameters;

467: p_return_status := FND_API.G_RET_STS_SUCCESS;
468: begin
469: select DEFAULT_TERRITORY
470: into l_territory_default
471: from ar_system_parameters;
472: exception
473: when no_data_found then
474: arp_util.debug('System option not defined for the org');
475: when others then

Line 1454: ar_system_parameters.pay_unrelated_invoices_flag%type;

1450: l_match_postal_code hz_locations.postal_code%type;
1451: l_match_address_id NUMBER :=NULL;
1452: l_match_site_use_id NUMBER :=NULL;
1453: l_pay_unrelated_invoices_flag
1454: ar_system_parameters.pay_unrelated_invoices_flag%type;
1455: l_bill_to_location hz_cust_site_uses.location%type;
1456: l_ship_to_location hz_cust_site_uses.location%type;
1457: l_dft_bill_to_location hz_cust_site_uses.location%type;
1458: l_dft_ship_to_location hz_cust_site_uses.location%type;