APPS.PA_FORECAST_ITEMS_GEN_WF_PKG dependencies on PA_PROJECT_ASSIGNMENTS

Line 69: FROM pa_project_assignments

65:
66: BEGIN
67:
68: SELECT project_id INTO l_project_id
69: FROM pa_project_assignments
70: WHERE assignment_id = p_assignment_id;
71:
72:
73: EXCEPTION

Line 77: -- in pa_project_assignments

73: EXCEPTION
74:
75: WHEN no_data_found THEN
76: -- In delete assignment the assignment will not exist
77: -- in pa_project_assignments
78: l_project_id := null;
79: l_wf_type_code := 'FORECAST_DELETION';
80: null;
81: END;

Line 103: FROM pa_project_assignments

99: SELECT name
100: INTO l_name
101: FROM pa_organizations_expend_v
102: WHERE organization_id = ( select expenditure_organization_id
103: FROM pa_project_assignments
104: WHERE assignment_id = p_assignment_id);
105:
106: and instead used the select statement below note that also called the org_name
107: translation function.

Line 112: from pa_project_assignments

108: */
109:
110: select pa_expenditures_utils.GetOrgTlName(expenditure_organization_id)
111: into l_name
112: from pa_project_assignments
113: where assignment_id = p_assignment_id;
114:
115: EXCEPTION
116: