DBA Data[Home] [Help]

APPS.GCS_RULES_PROCESSOR dependencies on GCS_FORMULA_STATEMENTS

Line 85: FROM GCS_FORMULA_STATEMENTS

81:
82: --See initRefTables procedure
83: cursor getStmts(ruleTypeCode varchar2) is
84: SELECT statement_num, statement_text, compiled_variables
85: FROM GCS_FORMULA_STATEMENTS
86: WHERE rule_type_code = ruleTypeCode
87: OR rule_type_code = 'E'
88: ORDER BY statement_num;
89: TYPE stmtsTable IS TABLE OF getStmts%ROWTYPE INDEX BY BINARY_INTEGER;

Line 3080: --The gcs_formula_statements table uses offset index values starting with 0

3076: t2Amt.DELETE;
3077: peAmt.DELETE;
3078: ceAmt.DELETE;
3079: eeAmt.DELETE;
3080: --The gcs_formula_statements table uses offset index values starting with 0
3081: --The bulk select that fills the stmts array assigns keys starting with 1
3082: --JH 4.29.04: updated the offset.
3083: stmt := 0;
3084: