DBA Data[Home] [Help]

APPS.PA_TASKS_MAINT_PVT dependencies on USER_SYNONYMS

Line 4681: FROM user_synonyms syn, all_tab_columns col

4677:
4678: CURSOR cur_data_length(c_pa_schema_name VARCHAR2)
4679: IS
4680: SELECT column_name, data_length
4681: FROM user_synonyms syn, all_tab_columns col
4682: WHERE col.table_name = 'PA_TASKS'
4683: and col.owner = syn.table_owner
4684: and col.table_name = syn.table_name
4685: AND col.owner = c_pa_schema_name

Line 5034: FROM user_synonyms syn, all_tab_columns col

5030:
5031: CURSOR cur_data_length(c_pa_schema_name VARCHAR2)
5032: IS
5033: SELECT column_name, data_length
5034: FROM user_synonyms syn, all_tab_columns col
5035: WHERE col.table_name = 'PA_TASKS'
5036: and col.owner = syn.table_owner
5037: and col.table_name = syn.table_name
5038: AND col.owner = c_pa_schema_name

Line 5342: FROM user_synonyms syn, all_tab_columns col

5338:
5339: CURSOR cur_data_length(c_pa_schema_name VARCHAR2)
5340: IS
5341: SELECT column_name, data_length
5342: FROM user_synonyms syn, all_tab_columns col
5343: WHERE col.table_name = 'PA_TASKS'
5344: and col.owner = syn.table_owner
5345: and col.table_name = syn.table_name
5346: AND col.owner = c_pa_schema_name