DBA Data[Home] [Help]

APPS.PA_RELATIONSHIP_PVT dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 1888: l_subtype_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

1884: l_pred_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1885: l_suc_ver_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1886: l_suc_proj_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1887: l_comment_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
1888: l_subtype_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
1889: l_lag_days_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1890:
1891: CURSOR get_dependency2 IS
1892: select /*+ leading(dt1) use_nl(dt1 rel) */ -- hint added per performance team recommendation for bug 5576900