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 473: from ar_system_parameters;

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

Line 1456: ar_system_parameters.pay_unrelated_invoices_flag%type;

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