APPS.PAY_MX_ARCHIVE_DBI_PKG dependencies on FF_ROUTE_PARAMETERS

Line 80: INSERT INTO ff_route_parameters

76: SYSDATE
77: );
78:
79: -- Define the route parameter
80: INSERT INTO ff_route_parameters
81: (
82: route_parameter_id,
83: route_id,
84: data_type,

Line 88: SELECT ff_route_parameters_s.NEXTVAL,

84: data_type,
85: parameter_name,
86: sequence_no
87: )
88: SELECT ff_route_parameters_s.NEXTVAL,
89: ff_routes_s.CURRVAL,
90: 'N',
91: 'User Entity ID',
92: 1

Line 237: FROM ff_route_parameters

233:
234: -- Find the User Entity Route parameter that goes with the archive route
235: SELECT route_parameter_id
236: INTO l_route_parameter_id
237: FROM ff_route_parameters
238: WHERE parameter_name = 'User Entity ID'
239: AND route_id = l_route_id;
240:
241: BEGIN