DBA Data[Home] [Help]

APPS.GCS_RULES_PROCESSOR dependencies on GCS_ELIM_RULE_STEPS_B

Line 410: FROM gcs_elim_rule_steps_b

406: '%MI',
407: 1 - p_ownership_percent),
408: '%OWN',
409: p_ownership_percent)
410: FROM gcs_elim_rule_steps_b
411: WHERE rule_id = p_rule_id;
412:
413: --+========================================================================+
414: -- PACKAGE Private Members

Line 3047: varList GCS_ELIM_RULE_STEPS_B.compiled_variables%TYPE;

3043:
3044: dc1 integer;
3045: i number := 0; --a re-usable index
3046: stmt number := 0; --SQL statement index
3047: varList GCS_ELIM_RULE_STEPS_B.compiled_variables%TYPE;
3048: varName varchar2(10);
3049:
3050: fetchSize CONSTANT integer := 2000;
3051: listDelim CONSTANT varchar2(10) := ',';

Line 4585: from gcs_rule_scope_dims grsd, gcs_elim_rule_steps_b grsb

4581: 'Inserting into gcs_entry_lines');
4582:
4583: select decode(count(1), 0, 'N', 'Y')
4584: into offsetFlag
4585: from gcs_rule_scope_dims grsd, gcs_elim_rule_steps_b grsb
4586: where grsd.column_name = 'LINE_ITEM_ID'
4587: and grsd.offset_member_id is not null
4588: and grsb.rule_step_id = grsd.rule_step_id
4589: and grsb.rule_id = ruleId;