DBA Data[Home] [Help]

APPS.FTE_ACS_CACHE_PKG dependencies on FTE_SEL_RESULT_ASSIGNMENTS

Line 4011: from fte_sel_result_assignments fsras

4007: -- get results for a rule
4008: -- -----------------------------------------------------------------
4009: cursor c_get_result_id IS
4010: select fsras.result_id
4011: from fte_sel_result_assignments fsras
4012: where fsras.rule_id = p_rule_id;
4013:
4014: -- -----------------------------------------------------------------
4015: -- get result attributes names and values

Line 4211: -- COMMENT : For a given rule id queries FTE_SEL_RESULT_ASSIGNMENTS and FTE_SEL_RESULT_ATTRIBUTES

4207: -- PARAMETERS: p_rule_id Rule Id.
4208: -- x_result_tab Results Attributes associated with the rule.
4209: -- x_return_status Return Status
4210: --
4211: -- COMMENT : For a given rule id queries FTE_SEL_RESULT_ASSIGNMENTS and FTE_SEL_RESULT_ATTRIBUTES
4212: -- to return the result.Caching is used in this procedure.
4213: --
4214: --
4215: -- ALGORITHM :