APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on PQH_TABLE_ROUTE

Line 51: from pqh_table_route

47:
48:
49: cursor c_table_route (c_table_alias VARCHAR) IS
50: select table_route_id
51: from pqh_table_route
52: WHERE table_alias = c_table_alias;
53:
54:
55:

Line 1316: from pqh_table_route

1312: l_object_version_number NUMBER;
1313:
1314: cursor c_table_route (c_table_alias VARCHAR) IS
1315: select table_route_id
1316: from pqh_table_route
1317: WHERE table_alias = c_table_alias;
1318: BEGIN
1319:
1320:

Line 3598: pqh_table_route trt

3594: yrp.business_group_id = p_business_group_id
3595: and not exists (
3596: select null
3597: from ben_copy_entity_results cpe,
3598: pqh_table_route trt
3599: where copy_entity_txn_id = p_copy_entity_txn_id
3600: and trt.table_route_id = cpe.table_route_id
3601:
3602: and trt.table_alias = c_table_alias

Line 3609: from pqh_table_route trt

3605: );
3606:
3607: cursor c_table_route(c_parent_table_alias varchar2) is
3608: select table_route_id
3609: from pqh_table_route trt
3610: where
3611: trt.table_alias = c_parent_table_alias ;
3612:
3613:

Line 3901: l_table_name pqh_table_route.where_clause%TYPE;

3897: and information1=p_information1
3898: and p_effective_date between nvl(information2,p_effective_date) and nvl(information3,p_effective_date);
3899:
3900: l_name ben_copy_entity_results.information170%TYPE;
3901: l_table_name pqh_table_route.where_clause%TYPE;
3902: l_effective_date pqh_copy_entity_txns.SRC_EFFECTIVE_DATE%TYPE;
3903: l_bg_id pqh_copy_entity_txns.CONTEXT_BUSINESS_GROUP_ID%TYPE;
3904: Begin
3905: get_txn_details(