APPS.FFDBITEM dependencies on FF_CONTEXTS

Line 139: FROM FF_CONTEXTS FC,

135: cursor route_contexts is
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;

Line 146: l_context_name FF_CONTEXTS.CONTEXT_NAME%TYPE;

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
150: hr_utility.set_location('ffdbitem.process_contexts',1);

Line 147: l_data_type FF_CONTEXTS.DATA_TYPE%TYPE;

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
150: hr_utility.set_location('ffdbitem.process_contexts',1);
151: open route_contexts;