APPS.PQH_GSP_PRGRULES dependencies on PQH_TABLE_ROUTE

Line 1115: L_Table_Name Pqh_Table_Route.Display_Name%TYPE;

1111: l_Prtn_Elig_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1112: l_Prtn_Elig_Prfl_Ovn BEN_COPY_ENTITY_RESULTS.Object_version_number%TYPE;
1113: L_PRTN_ELIG_PRFL_ID Ben_Prtn_Elig_Prfl_f.Prtn_Elig_Prfl_Id%TYPE;
1114: l_Table_Route_Id BEN_COPY_ENTITY_RESULTS.Table_Route_Id%TYPE;
1115: L_Table_Name Pqh_Table_Route.Display_Name%TYPE;
1116: l_Prtn_Elig_id Pqh_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1117: l_DelPrtn_Elig_id Pqh_Copy_Entity_Results.Copy_Entity_Result_Id%TYPE;
1118: l_InsYN Varchar2(1) := 'N';
1119: l_DelYN Varchar2(1) := 'N';

Line 1150: -- from Pqh_Table_Route bug5763511

1146: where Copy_Entity_Txn_Id = p_Copy_Entity_txn_Id;
1147:
1148: Cursor TablRoute (p_table_alias IN Varchar2) is
1149: Select Table_Route_id, Substr(Display_name,1,30)
1150: -- from Pqh_Table_Route bug5763511
1151: from Pqh_Table_Route_vl
1152: Where table_alias = p_table_alias;
1153:
1154: Cursor Ovn is

Line 1151: from Pqh_Table_Route_vl

1147:
1148: Cursor TablRoute (p_table_alias IN Varchar2) is
1149: Select Table_Route_id, Substr(Display_name,1,30)
1150: -- from Pqh_Table_Route bug5763511
1151: from Pqh_Table_Route_vl
1152: Where table_alias = p_table_alias;
1153:
1154: Cursor Ovn is
1155: Select object_version_Number