APPS.FFDBITEM dependencies on FF_ROUTE_PARAMETER_VALUES

Line 67: FF_ROUTE_PARAMETER_VALUES RPV

63: RP.PARAMETER_NAME,
64: UPPER(RP.DATA_TYPE),
65: RPV.VALUE
66: FROM FF_ROUTE_PARAMETERS RP,
67: FF_ROUTE_PARAMETER_VALUES RPV
68: WHERE RP.ROUTE_ID = p_route_id
69: AND RP.ROUTE_PARAMETER_ID = RPV.ROUTE_PARAMETER_ID
70: AND RPV.USER_ENTITY_ID = p_user_entity_id
71: ORDER BY RP.SEQUENCE_NO;

Line 76: l_value FF_ROUTE_PARAMETER_VALUES.VALUE%TYPE;

72: --
73: l_sequence_no FF_ROUTE_PARAMETERS.SEQUENCE_NO%TYPE;
74: l_parameter_name FF_ROUTE_PARAMETERS.PARAMETER_NAME%TYPE;
75: l_data_type FF_ROUTE_PARAMETERS.DATA_TYPE%TYPE;
76: l_value FF_ROUTE_PARAMETER_VALUES.VALUE%TYPE;
77: --
78: begin
79: hr_utility.set_location('ffdbitem.process_route_parameters',1);
80: open route_parms;