APPS.CSE_FAC_INSERVICE_PKG dependencies on PA_PROJECTS_ALL

Line 95: FROM pa_projects_all

91: l_in_srv_pa_attr_rec cse_datastructures_pub.proj_itm_insv_pa_attr_rec_type;
92:
93: CURSOR project_id_cur(p_project_num IN VARCHAR2) IS
94: SELECT project_id
95: FROM pa_projects_all
96: WHERE segment1 = p_project_num;
97:
98: CURSOR task_id_cur(p_project_id in number, p_task_num in varchar2) IS
99: SELECT task_id

Line 217: FROM pa_projects_all

213: IF l_depreciable = 'N' THEN
214:
215: SELECT org_id
216: INTO l_in_srv_pa_attr_rec.org_id
217: FROM pa_projects_all
218: WHERE project_id = l_project_id;
219:
220: l_in_srv_pa_attr_rec.item_id := inservice_inst_rec.inventory_item_id;
221: l_in_srv_pa_attr_rec.inv_master_org_id := inservice_inst_rec.last_vld_organization_id;

Line 476: FROM pa_projects_all

472: org_id
473: INTO l_project_num,
474: l_project_name,
475: l_org_id
476: FROM pa_projects_all
477: WHERE project_id = p_project_id;
478:
479: debug(' project_name : '||l_project_name);
480: