DBA Data[Home] [Help]

APPS.ARRX_TX dependencies on AR_LOOKUPS

Line 761: select MEANING into YES_NO_Y from ar_lookups

757: IF var.end_transaction_date IS NOT NULL THEN
758: dbms_sql.bind_variable(c, 'end_transaction_date', var.end_transaction_date);
759: END IF;
760:
761: select MEANING into YES_NO_Y from ar_lookups
762: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';
763: select MEANING into YES_NO_N from ar_lookups
764: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'N';
765: dbms_sql.bind_variable(c, 'YES', YES_NO_Y);

Line 763: select MEANING into YES_NO_N from ar_lookups

759: END IF;
760:
761: select MEANING into YES_NO_Y from ar_lookups
762: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';
763: select MEANING into YES_NO_N from ar_lookups
764: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'N';
765: dbms_sql.bind_variable(c, 'YES', YES_NO_Y);
766: dbms_sql.bind_variable(c, 'NO', YES_NO_N);
767: