APPS.ARRX_ADJ dependencies on AR_LOOKUPS

Line 579: ar_lookups ladjtype,

575: fa_rx_util_pkg.debug('Assign FROM Clause using ALL tables');
576: -- Bug 1719611 Tim Dexter - added ar_distributions
577: fa_rx_util_pkg.from_clause := 'hz_cust_accounts_all cust,
578: hz_parties party,
579: ar_lookups ladjtype,
580: ar_payment_schedules_all pay,
581: ra_customer_trx_all trx,
582: ar_adjustments_all adj,
583: ar_lookups look,

Line 583: ar_lookups look,

579: ar_lookups ladjtype,
580: ar_payment_schedules_all pay,
581: ra_customer_trx_all trx,
582: ar_adjustments_all adj,
583: ar_lookups look,
584: hz_organization_profiles org, /*bug5968198*/
585: hz_person_profiles per' /*bug5968198*/
586: || SHOW_BILL_FROM;
587:

Line 798: select meaning into l_Yes from AR_LOOKUPS

794: IF var.p_doc_seq_high IS NOT NULL THEN
795: dbms_sql.bind_variable(c, 'p_doc_seq_high',var.p_doc_seq_high);
796: END IF;
797:
798: select meaning into l_Yes from AR_LOOKUPS
799: where lookup_type = 'YES/NO' and lookup_code = 'Y';
800:
801: select meaning into l_No from AR_LOOKUPS
802: where lookup_type = 'YES/NO' and lookup_code = 'N';

Line 801: select meaning into l_No from AR_LOOKUPS

797:
798: select meaning into l_Yes from AR_LOOKUPS
799: where lookup_type = 'YES/NO' and lookup_code = 'Y';
800:
801: select meaning into l_No from AR_LOOKUPS
802: where lookup_type = 'YES/NO' and lookup_code = 'N';
803:
804: dbms_sql.bind_variable(c, 'c_Yes', l_Yes);
805: dbms_sql.bind_variable(c, 'c_No', l_No);