APPS.BENUTILS dependencies on ALL_TAB_COLUMNS

Line 2784: from all_tab_columns t,

2780: l_return boolean;
2781: --
2782: cursor c1(l_oracle_schema in varchar2) is
2783: select t.column_name
2784: from all_tab_columns t,
2785: all_cons_columns c,
2786: all_constraints a
2787: where a.constraint_type = 'P'
2788: and a.table_name = p_tablename

Line 2852: from all_tab_columns t

2848: l_return boolean;
2849: --
2850: cursor c1(l_oracle_schema in varchar2) is
2851: select null
2852: from all_tab_columns t
2853: where t.table_name = p_tablename
2854: and (substr(t.column_name,length(t.column_name)-2,3) = '_CD'
2855: or substr(t.column_name,length(t.column_name)-3,4) = '_IND'
2856: or substr(t.column_name,length(t.column_name)-3,4) = '_UOM'

Line 2907: from all_tab_columns t,

2903: l_return boolean;
2904: --
2905: cursor c1(l_oracle_schema in varchar2) is
2906: select c.column_name
2907: from all_tab_columns t,
2908: all_cons_columns c,
2909: all_constraints a
2910: where a.constraint_type = 'P'
2911: and a.table_name = p_tablename

Line 2957: from all_tab_columns a

2953: l_return boolean;
2954: --
2955: cursor c1(l_oracle_schema in varchar2) is
2956: select null
2957: from all_tab_columns a
2958: where a.column_name = 'BUSINESS_GROUP_ID'
2959: and a.table_name = p_tablename
2960: and a.owner = upper(l_oracle_schema);
2961: --

Line 3028: from all_tab_columns utc

3024: l_return boolean;
3025: --
3026: cursor c1(l_oracle_schema in varchar2) is
3027: select null
3028: from all_tab_columns utc
3029: where utc.table_name = p_tablename
3030: and utc.column_name like '%ATTRIBUTE%'
3031: and utc.owner = upper(l_oracle_schema);
3032: --