APPS.PSP_EFFORTS_PKG dependencies on PSP_TEMPLATE_PROJECTS

Line 71: FROM psp_template_projects

67: BEGIN
68: BEGIN
69: SELECT 'x'
70: INTO t_dummy
71: FROM psp_template_projects
72: WHERE template_id = a_template_id AND
73: ROWNUM = 1;
74: EXCEPTION
75: WHEN NO_DATA_FOUND THEN

Line 81: FROM psp_template_projects

77: END;
78: ---
79: SELECT 'x'
80: INTO t_dummy
81: FROM psp_template_projects
82: WHERE template_id = a_template_id AND
83: project_id = t_project_id;
84: RETURN(1);
85: EXCEPTION

Line 311: PSP_TEMPLATE_PROJECTS_PKG.delete_row(t_old_template_id);

307: PSP_TEMPLATE_AWARDS_PKG.delete_row(t_old_template_id);
308: IF (SQL%NOTFOUND) THEN
309: NULL;
310: END IF;
311: PSP_TEMPLATE_PROJECTS_PKG.delete_row(t_old_template_id);
312: IF (SQL%NOTFOUND) THEN
313: NULL;
314: END IF;
315: PSP_TEMPLATE_ORGANIZATIONS_PKG.delete_row(t_old_template_id);

Line 666: OR psl.project_id IN (SELECT project_id FROM psp_template_projects

662: AND (paf.effective_start_date <= pet.end_date AND paf.effective_end_date >= pet.begin_date))
663: --End of code for Bug 2892637
664: -- Start bug fix:1988747 by Ritesh on Sep 12, 2001
665: OR psl.gl_code_combination_id = pet.gl_code_combination_id
666: OR psl.project_id IN (SELECT project_id FROM psp_template_projects
667: WHERE template_id = a_template_id)
668: OR psl.award_id IN (SELECT award_id FROM psp_template_awards
669: WHERE template_id = a_template_id)
670: OR psl.expenditure_organization_id IN (SELECT expenditure_organization_id FROM psp_template_organizations