APPS.FFDBITEM dependencies on FF_ROUTE_PARAMETERS

Line 66: FROM FF_ROUTE_PARAMETERS RP,

62: SELECT RP.SEQUENCE_NO,
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

Line 73: l_sequence_no FF_ROUTE_PARAMETERS.SEQUENCE_NO%TYPE;

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;
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: --

Line 74: l_parameter_name FF_ROUTE_PARAMETERS.PARAMETER_NAME%TYPE;

70: AND RPV.USER_ENTITY_ID = p_user_entity_id
71: ORDER BY RP.SEQUENCE_NO;
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

Line 75: l_data_type FF_ROUTE_PARAMETERS.DATA_TYPE%TYPE;

71: ORDER BY RP.SEQUENCE_NO;
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);