APPS.PSP_EFFORTS_PKG dependencies on PSP_TEMPLATE_ORGANIZATIONS

Line 123: FROM psp_template_organizations

119: BEGIN
120: BEGIN
121: SELECT 'x'
122: INTO t_dummy
123: FROM psp_template_organizations
124: WHERE template_id = a_template_id AND
125: ROWNUM = 1;
126: EXCEPTION
127: WHEN NO_DATA_FOUND THEN

Line 133: FROM psp_template_organizations

129: END;
130: ---
131: SELECT 'x'
132: INTO t_dummy
133: FROM psp_template_organizations
134: WHERE template_id = a_template_id AND
135: expenditure_organization_id = t_expenditure_organization_id;
136: RETURN(1);
137: EXCEPTION

Line 315: PSP_TEMPLATE_ORGANIZATIONS_PKG.delete_row(t_old_template_id);

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);
316: IF (SQL%NOTFOUND) THEN
317: NULL;
318: END IF;
319: PSP_EFT_REPORT_TEMPLATES_PKG.delete_row(t_old_template_id);

Line 670: OR psl.expenditure_organization_id IN (SELECT expenditure_organization_id FROM psp_template_organizations

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
673: )
674: and