APPS.IEC_WHERECLAUSE_PVT dependencies on IEC_O_ALG_OP_DEFS_B

Line 16: TYPE SQL_OPERATOR_TBL IS TABLE OF iec_o_alg_op_defs_b.sql_operator%TYPE;

12: TYPE COMBINATION_CODE_TBL IS TABLE OF iec_g_field_criteria.combination_code%TYPE;
13: TYPE FIELD_NAME_TBL IS TABLE OF iec_g_fields.field_name%TYPE;
14: TYPE FIELD_VALUE_TBL IS TABLE OF iec_g_fields.field_value%TYPE;
15: TYPE OPERATOR_CODE_TBL IS TABLE OF iec_g_fields.operator_code%TYPE;
16: TYPE SQL_OPERATOR_TBL IS TABLE OF iec_o_alg_op_defs_b.sql_operator%TYPE;
17: TYPE UNARY_FLAG_TBL IS TABLE OF iec_o_alg_op_defs_b.is_unary_flag%TYPE;
18: l_rule_id_tbl RULE_ID_TBL;
19: l_criteria_id_tbl CRITERIA_ID_TBL;
20: l_comb_code_tbl COMBINATION_CODE_TBL;

Line 17: TYPE UNARY_FLAG_TBL IS TABLE OF iec_o_alg_op_defs_b.is_unary_flag%TYPE;

13: TYPE FIELD_NAME_TBL IS TABLE OF iec_g_fields.field_name%TYPE;
14: TYPE FIELD_VALUE_TBL IS TABLE OF iec_g_fields.field_value%TYPE;
15: TYPE OPERATOR_CODE_TBL IS TABLE OF iec_g_fields.operator_code%TYPE;
16: TYPE SQL_OPERATOR_TBL IS TABLE OF iec_o_alg_op_defs_b.sql_operator%TYPE;
17: TYPE UNARY_FLAG_TBL IS TABLE OF iec_o_alg_op_defs_b.is_unary_flag%TYPE;
18: l_rule_id_tbl RULE_ID_TBL;
19: l_criteria_id_tbl CRITERIA_ID_TBL;
20: l_comb_code_tbl COMBINATION_CODE_TBL;
21: l_field_name_tbl FIELD_NAME_TBL;

Line 60: l_unary_flag_tbl from iec_g_fields A, iec_o_alg_op_defs_b B

56: UPPER(LTRIM(RTRIM(A.operator_code,' '),' ')),
57: UPPER(LTRIM(RTRIM(B.sql_operator,' '),' ')),
58: B.is_unary_flag bulk collect into l_field_name_tbl,l_field_value_tbl,
59: l_operator_code_tbl,l_sql_operator_tbl,
60: l_unary_flag_tbl from iec_g_fields A, iec_o_alg_op_defs_b B
61: where A.criteria_id = l_criteria_id_tbl(k) and A.operator_code = B.operator_code;
62:
63: l_field_flag := 'Y';
64: for i in 1 .. l_field_name_tbl.COUNT