APPS.HR_CONSTRAINT_CHECK dependencies on ALL_CONSTRAINTS

Line 44: from all_constraints

40: cursor csr_find_ben_constraints (c_per_owner in varchar2,
41: c_ben_owner in varchar2) is
42: select table_name,
43: constraint_name
44: from all_constraints
45: where table_name like 'BEN_%'
46: and constraint_name not like 'SYS_%'
47: and ((owner = c_per_owner) or
48: (owner = c_ben_owner))

Line 54: from all_constraints

50: --
51: cursor csr_find_per_constraints (c_per_owner in varchar2) is
52: select table_name,
53: constraint_name
54: from all_constraints
55: where ((table_name like 'PER_%') or
56: ((table_name like 'HR_%') and
57: (table_name not like 'HRI_%')))
58: and constraint_name not like 'SYS_%'

Line 65: from all_constraints

61: --
62: cursor csr_find_hri_constraints (c_owner in varchar2) is
63: select table_name,
64: constraint_name
65: from all_constraints
66: where ((table_name like 'HR_EDW%') or
67: (table_name like 'HRI_%'))
68: and constraint_name not like 'SYS_%'
69: and owner = c_owner

Line 76: from all_constraints

72: cursor csr_find_constraints(c_prod in varchar2,
73: c_owner in varchar2) is
74: select table_name,
75: constraint_name
76: from all_constraints
77: where table_name like c_prod
78: and constraint_name not like 'SYS_%'
79: and owner = c_owner
80: order by table_name, constraint_name;