DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on GL_CODE_COMBINATIONS

Line 502: from GL_CODE_COMBINATIONS

498:
499: elsif cr.COST_OF_SALES_ACCOUNT is not null then
500: begin
501: select 'x' into temp
502: from GL_CODE_COMBINATIONS
503: where CODE_COMBINATION_ID = cr.COST_OF_SALES_ACCOUNT
504: and CHART_OF_ACCOUNTS_ID = chart_of_acc_id
505: and nvl(START_DATE_ACTIVE,sysdate) <= sysdate
506: and nvl(END_DATE_ACTIVE,sysdate) >= sysdate

Line 545: from GL_CODE_COMBINATIONS

541:
542: elsif cr.SALES_ACCOUNT is not null then
543: begin
544: select 'x' into temp
545: from GL_CODE_COMBINATIONS
546: where CODE_COMBINATION_ID = cr.SALES_ACCOUNT
547: and CHART_OF_ACCOUNTS_ID = chart_of_acc_id
548: and nvl(START_DATE_ACTIVE,sysdate) <= sysdate
549: and nvl(END_DATE_ACTIVE,sysdate) >= sysdate

Line 589: from GL_CODE_COMBINATIONS

585:
586: elsif cr.EXPENSE_ACCOUNT is not null then
587: begin
588: select 'x' into temp
589: from GL_CODE_COMBINATIONS
590: where CODE_COMBINATION_ID = cr.EXPENSE_ACCOUNT
591: and CHART_OF_ACCOUNTS_ID = chart_of_acc_id
592: and nvl(START_DATE_ACTIVE,sysdate) <= sysdate
593: and nvl(END_DATE_ACTIVE,sysdate) >= sysdate

Line 626: from GL_CODE_COMBINATIONS

622: -- validate Encumbrance Account
623: if cr.ENCUMBRANCE_ACCOUNT is not null then
624: begin
625: select 'x' into temp
626: from GL_CODE_COMBINATIONS
627: where CODE_COMBINATION_ID = cr.ENCUMBRANCE_ACCOUNT
628: and CHART_OF_ACCOUNTS_ID = chart_of_acc_id
629: and nvl(START_DATE_ACTIVE,sysdate) <= sysdate
630: and nvl(END_DATE_ACTIVE,sysdate) >= sysdate