DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on CST_WIP_SUB_LEDGER_ID_S

Line 7472: select DECODE(p_acct_line_type, 15, -1,1) * CST_WIP_SUB_LEDGER_ID_S.NEXTVAL,

7468: program_id,
7469: program_update_date,
7470: encumbrance_type_id -- Bug 9356654 WIP Encumbrance enhancement Change 3
7471: )
7472: select DECODE(p_acct_line_type, 15, -1,1) * CST_WIP_SUB_LEDGER_ID_S.NEXTVAL,
7473: p_txn_id,
7474: p_ref_acct,
7475: sysdate,
7476: p_user_id,

Line 7575: select CST_WIP_SUB_LEDGER_ID_S.NEXTVAL,

7571: program_application_id,
7572: program_id,
7573: program_update_date
7574: )
7575: select CST_WIP_SUB_LEDGER_ID_S.NEXTVAL,
7576: p_txn_id,
7577: p_ref_acct,
7578: sysdate,
7579: p_user_id,

Line 8876: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL

8872: 5,l_ovh_var_total) <> 0;
8873:
8874: l_stmt_num := 65;
8875: UPDATE WIP_TRANSACTION_ACCOUNTS
8876: SET WIP_SUB_LEDGER_ID = CST_WIP_SUB_LEDGER_ID_S.NEXTVAL
8877: WHERE TRANSACTION_ID = c_route_rec.transaction_id;
8878:
8879:
8880: end if; --check for member assets count