APPS.PSP_WF_EFF_PKG dependencies on PSP_EFFORT_REPORTS

Line 41: FROM psp_effort_reports

37: -- Start fix bug 954141. Added the max(version) and group by in the
38: -- cursor below. Concatenate these two and initiate WF.
39: CURSOR get_report_id_csr IS
40: SELECT effort_report_id, max(version_num)
41: FROM psp_effort_reports
42: WHERE template_id=a_template_id
43: GROUP BY effort_report_id;
44:
45: CURSOR get_emp_id_csr IS

Line 47: FROM psp_effort_reports

43: GROUP BY effort_report_id;
44:
45: CURSOR get_emp_id_csr IS
46: SELECT person_id
47: FROM psp_effort_reports
48: WHERE effort_report_id = l_report_id;
49:
50: CURSOR get_period_details_csr IS
51: SELECT Begin_date,

Line 408: FROM psp_effort_reports

404: l_rep_id := substr(itemkey, 1, length(itemkey) - 1 );
405: -- Bug# 954141
406:
407: SELECT max(version_num) INTO l_version_num
408: FROM psp_effort_reports
409: -- WHERE effort_report_id = to_number(itemkey);
410: WHERE effort_report_id = to_number(l_rep_id);
411: --Bug# 954141
412:

Line 413: UPDATE psp_effort_reports

409: -- WHERE effort_report_id = to_number(itemkey);
410: WHERE effort_report_id = to_number(l_rep_id);
411: --Bug# 954141
412:
413: UPDATE psp_effort_reports
414: SET status_code = status
415: -- WHERE effort_report_id = to_number(itemkey);
416: WHERE effort_report_id = to_number(l_rep_id)
417: AND version_num = l_version_num;