[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select set_of_books_id
into var.books_id
from ar_system_parameters_all
where org_id = p_reporting_entity;
'arrx_oth.bind(:CURSOR_SELECT);',
select CHART_OF_ACCOUNTS_ID,CURRENCY_CODE,NAME
into var.chart_of_accounts_id,var.functional_currency_code,var.organization_name
from GL_SETS_OF_BOOKS
where SET_OF_BOOKS_ID = var.books_id;
fa_rx_util_pkg.debug('ARTX_ASSIGN_SELECT_LIST');
AND RB.BATCH_ID (+) = CR.SELECTED_REMITTANCE_BATCH_ID
-- AND AB.BANK_ACCOUNT_ID (+) = CR.REMITTANCE_BANK_ACCOUNT_ID
AND CBA.BANK_ACCT_USE_ID(+) = CR.REMIT_BANK_ACCT_USE_ID
AND CBA.BANK_ACCOUNT_ID = AB.BANK_ACCOUNT_ID
AND BB.BRANCH_PARTY_ID = AB.BANK_BRANCH_ID
AND CUST.CUST_ACCOUNT_ID(+) = CR.PAY_FROM_CUSTOMER
AND CUST.PARTY_ID = PARTY.PARTY_ID(+)
AND GLS.SET_OF_BOOKS_ID = CR.SET_OF_BOOKS_ID
AND GLC.CODE_COMBINATION_ID(+) = APP.CODE_COMBINATION_ID
AND CR.CASH_RECEIPT_ID = CRHFIRST.CASH_RECEIPT_ID
AND CRHFIRST.FIRST_POSTED_RECORD_FLAG = ''Y''
AND CRHFIRST.BATCH_ID = RBFIRST.BATCH_ID(+)
AND BSFIRST.BATCH_SOURCE_ID(+) = RBFIRST.BATCH_SOURCE_ID ' ||
CO_SEG_WHERE || ' ' ||
GL_DATE_WHERE || ' ' ||
CURRENCY_CODE_WHERE || ' ' ||
CUSTOMER_NAME_WHERE || ' ' ||
CUSTOMER_NUMBER_WHERE || ' ' ||
RECEIPT_DATE_WHERE || ' ' ||
APPLY_DATE_WHERE || ' ' ||
REMIT_BATCH_WHERE || ' ' ||
RECEIPT_BATCH_WHERE || ' ' ||
RECEIPT_NUMBER_WHERE || ' ' ||
APP_TYPE_WHERE || ' ' ||
L_APP_ORG_WHERE || ' ' ||
L_CR_ORG_WHERE || ' ' ||
L_CRH_ORG_WHERE || ' ' ||
-- L_PS_ORG_WHERE || ' ' ||
L_CUST_ORG_WHERE || ' ' ||
L_BS_ORG_WHERE || ' ' ||
L_RB_ORG_WHERE || ' ' ||
L_AB_ORG_WHERE || ' ' ||
L_BSFIRST_ORG_WHERE || ' ' ||
L_CRHFIRST_ORG_WHERE || ' ' ||
L_RBFIRST_ORG_WHERE;