APPS.FFDBITEM dependencies on FF_ROUTE_CONTEXT_USAGES

Line 140: FF_ROUTE_CONTEXT_USAGES RCU

136: SELECT RCU.SEQUENCE_NO,
137: FC.CONTEXT_NAME,
138: UPPER(FC.DATA_TYPE)
139: FROM FF_CONTEXTS FC,
140: FF_ROUTE_CONTEXT_USAGES RCU
141: WHERE FC.CONTEXT_ID = RCU.CONTEXT_ID
142: AND RCU.ROUTE_ID = p_route_id
143: ORDER BY RCU.SEQUENCE_NO;
144: --

Line 145: l_sequence_no FF_ROUTE_CONTEXT_USAGES.SEQUENCE_NO%TYPE;

141: WHERE FC.CONTEXT_ID = RCU.CONTEXT_ID
142: AND RCU.ROUTE_ID = p_route_id
143: ORDER BY RCU.SEQUENCE_NO;
144: --
145: l_sequence_no FF_ROUTE_CONTEXT_USAGES.SEQUENCE_NO%TYPE;
146: l_context_name FF_CONTEXTS.CONTEXT_NAME%TYPE;
147: l_data_type FF_CONTEXTS.DATA_TYPE%TYPE;
148: --
149: begin

Line 238: SELECT CONTEXT_ID FROM FF_ROUTE_CONTEXT_USAGES IFRCU

234: OR (UE.BUSINESS_GROUP_ID IS NULL AND p_leg_code = UE.LEGISLATION_CODE )
235: OR (p_bg_id = UE.BUSINESS_GROUP_ID)
236: )
237: AND NOT EXISTS (
238: SELECT CONTEXT_ID FROM FF_ROUTE_CONTEXT_USAGES IFRCU
239: WHERE IFRCU.ROUTE_ID = FR.ROUTE_ID
240: MINUS
241: SELECT CONTEXT_ID FROM FF_FTYPE_CONTEXT_USAGES
242: WHERE FORMULA_TYPE_ID = p_formula_type_id