APPS.PSP_EFFORTS_PKG dependencies on PSP_TEMPLATE_AWARDS

Line 97: FROM psp_template_awards

93: BEGIN
94: BEGIN
95: SELECT 'x'
96: INTO t_dummy
97: FROM psp_template_awards
98: WHERE template_id = a_template_id AND
99: ROWNUM = 1;
100: EXCEPTION
101: WHEN NO_DATA_FOUND THEN

Line 107: FROM psp_template_awards

103: END;
104: ---
105: SELECT 'x'
106: INTO t_dummy
107: FROM psp_template_awards
108: WHERE template_id = a_template_id AND
109: award_id = t_award_id;
110: RETURN(1);
111: EXCEPTION

Line 307: PSP_TEMPLATE_AWARDS_PKG.delete_row(t_old_template_id);

303: LOOP
304: FETCH t_old_templates INTO t_old_template_id;
305: EXIT WHEN t_old_templates%NOTFOUND;
306: BEGIN
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);

Line 668: OR psl.award_id IN (SELECT award_id FROM psp_template_awards

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
671: WHERE template_id = a_template_id)
672: -- End bug fix:1988747