APPS.BEN_COPY_ENTITY_RESULTS_API dependencies on PQH_TABLE_ROUTE

Line 395: from pqh_table_route

391: l_object_version_number ben_copy_entity_results.object_version_number%TYPE;
392: --
393: cursor c_tbl_rt_id_with_alias is
394: select table_route_id
395: from pqh_table_route
396: where table_alias = p_table_alias;
397: --
398: cursor c_tbl_rt_id_with_name is
399: select table_route_id

Line 400: from pqh_table_route

396: where table_alias = p_table_alias;
397: --
398: cursor c_tbl_rt_id_with_name is
399: select table_route_id
400: from pqh_table_route
401: where where_clause = p_table_name;
402: --
403: cursor c_tbl_rt_alias_with_id is
404: select table_alias

Line 405: from pqh_table_route

401: where where_clause = p_table_name;
402: --
403: cursor c_tbl_rt_alias_with_id is
404: select table_alias
405: from pqh_table_route
406: where table_route_id = p_table_route_id;
407: --
408: l_table_route_id pqh_table_route.table_route_id%type;
409: l_table_alias pqh_table_route.table_alias%type;

Line 408: l_table_route_id pqh_table_route.table_route_id%type;

404: select table_alias
405: from pqh_table_route
406: where table_route_id = p_table_route_id;
407: --
408: l_table_route_id pqh_table_route.table_route_id%type;
409: l_table_alias pqh_table_route.table_alias%type;
410: --
411: l_dml_operation ben_copy_entity_results.dml_operation%type := 'REUSE';
412: l_status ben_copy_entity_results.status%type := 'VALID';

Line 409: l_table_alias pqh_table_route.table_alias%type;

405: from pqh_table_route
406: where table_route_id = p_table_route_id;
407: --
408: l_table_route_id pqh_table_route.table_route_id%type;
409: l_table_alias pqh_table_route.table_alias%type;
410: --
411: l_dml_operation ben_copy_entity_results.dml_operation%type := 'REUSE';
412: l_status ben_copy_entity_results.status%type := 'VALID';
413: l_datetrack_mode ben_copy_entity_results.datetrack_mode%type := 'INSERT';