DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PVT dependencies on ALL_TAB_COLUMNS

Line 4663: FROM all_tab_columns

4659:
4660: CURSOR cur_data_length(c_pa_schema_name VARCHAR2)
4661: IS
4662: SELECT column_name, data_length
4663: FROM all_tab_columns
4664: WHERE table_name = 'PA_TASKS'
4665: AND owner = c_pa_schema_name
4666: AND column_name IN ( 'TASK_NAME', 'LONG_TASK_NAME', 'TASK_NUMBER' );
4667:

Line 5014: FROM all_tab_columns

5010:
5011: CURSOR cur_data_length(c_pa_schema_name VARCHAR2)
5012: IS
5013: SELECT column_name, data_length
5014: FROM all_tab_columns
5015: WHERE table_name = 'PA_TASKS'
5016: AND owner = c_pa_schema_name
5017: AND column_name IN ( 'TASK_NAME', 'LONG_TASK_NAME', 'TASK_NUMBER' );
5018:

Line 5320: FROM all_tab_columns

5316:
5317: CURSOR cur_data_length(c_pa_schema_name VARCHAR2)
5318: IS
5319: SELECT column_name, data_length
5320: FROM all_tab_columns
5321: WHERE table_name = 'PA_TASKS'
5322: AND owner = c_pa_schema_name
5323: AND column_name IN ( 'TASK_NAME', 'LONG_TASK_NAME', 'TASK_NUMBER' );
5324: