DBA Data[Home] [Help]

APPS.PSP_WF_EFT_PKG dependencies on PSP_EFFORT_REPORTS

Line 82: FROM psp_effort_reports

78: l_ver := substr(itemkey, length(itemkey));
79: -- 8.31.99
80:
81: SELECT person_id, template_id INTO L_person_id,L_template_id
82: FROM psp_effort_reports
83: -- WHERE effort_report_id = to_number(itemkey); 8.31.99...use the l_itemkey
84: WHERE effort_report_id = to_number(l_itemkey)
85: AND version_num = to_number(l_ver); -- to get the correct record and avoid multiple row returns.
86: -- End 8.31.99

Line 258: FROM psp_effort_reports

254: l_ver := substr(itemkey, length(itemkey));
255: -- End 8.31.99
256:
257: SELECT person_id, template_id INTO L_person_id, l_template_id
258: FROM psp_effort_reports
259: --8.31.99 ....use the l_itemkey above...BUG#969850
260: -- WHERE effort_report_id = to_number(itemkey);
261: WHERE effort_report_id = to_number(l_itemkey)
262: AND version_num = to_number(l_ver); -- to get the correct record and avoid multiple row returns.