APPS.PAY_PWO_SHD dependencies on PAY_WCI_OCCUPATIONS

Line 61: from pay_wci_occupations

57: rate_id,
58: job_id,
59: comments,
60: object_version_number
61: from pay_wci_occupations
62: where occupation_id = p_occupation_id;
63: --
64: l_proc varchar2(72) := g_package||'api_updating';
65: l_fct_ret boolean;

Line 136: from pay_wci_occupations

132: rate_id,
133: job_id,
134: comments,
135: object_version_number
136: from pay_wci_occupations
137: where occupation_id = p_occupation_id
138: for update nowait;
139: --
140: l_proc varchar2(72) := g_package||'lck';

Line 179: hr_utility.set_message_token('TABLE_NAME', 'pay_wci_occupations');

175: -- The object is locked therefore we need to supply a meaningful
176: -- error message.
177: --
178: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
179: hr_utility.set_message_token('TABLE_NAME', 'pay_wci_occupations');
180: hr_utility.raise_error;
181: End lck;
182: --
183: -- ----------------------------------------------------------------------------