DBA Data[Home] [Help]

APPS.PSP_ERA_SHD dependencies on PSP_EFF_REPORT_APPROVALS

Line 101: from psp_eff_report_approvals

97: ,eff_information12
98: ,eff_information13
99: ,eff_information14
100: ,eff_information15
101: from psp_eff_report_approvals
102: where effort_report_approval_id = p_effort_report_approval_id;
103: --
104: l_fct_ret boolean;
105: --

Line 218: from psp_eff_report_approvals

214: ,eff_information12
215: ,eff_information13
216: ,eff_information14
217: ,eff_information15
218: from psp_eff_report_approvals
219: where effort_report_approval_id = p_effort_report_approval_id
220: for update nowait;
221: --
222: l_proc varchar2(72) := g_package||'lck';

Line 267: fnd_message.set_token('TABLE_NAME', 'psp_eff_report_approvals');

263: -- The object is locked therefore we need to supply a meaningful
264: -- error message.
265: --
266: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
267: fnd_message.set_token('TABLE_NAME', 'psp_eff_report_approvals');
268: fnd_message.raise_error;
269: End lck;
270: --
271: -- ----------------------------------------------------------------------------