DBA Data[Home] [Help]

APPS.ARRX_TX dependencies on AR_LOOKUPS

Line 743: select MEANING into YES_NO_Y from ar_lookups

739: IF var.end_transaction_date IS NOT NULL THEN
740: dbms_sql.bind_variable(c, 'end_transaction_date', var.end_transaction_date);
741: END IF;
742:
743: select MEANING into YES_NO_Y from ar_lookups
744: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';
745: select MEANING into YES_NO_N from ar_lookups
746: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'N';
747: dbms_sql.bind_variable(c, 'YES', YES_NO_Y);

Line 745: select MEANING into YES_NO_N from ar_lookups

741: END IF;
742:
743: select MEANING into YES_NO_Y from ar_lookups
744: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';
745: select MEANING into YES_NO_N from ar_lookups
746: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'N';
747: dbms_sql.bind_variable(c, 'YES', YES_NO_Y);
748: dbms_sql.bind_variable(c, 'NO', YES_NO_N);
749: