DBA Data[Home] [Help]

APPS.PA_FORECAST_ITEMS_GEN_WF_PKG dependencies on PA_EXPENDITURES_UTILS

Line 110: select pa_expenditures_utils.GetOrgTlName(expenditure_organization_id)

106: and instead used the select statement below note that also called the org_name
107: translation function.
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:

Line 127: SELECT pa_expenditures_utils.GetOrgTlName(resource_organization_id)

123: IF p_start_date IS NOT NULL AND p_end_date IS NOT NULL THEN
124:
125: BEGIN
126:
127: SELECT pa_expenditures_utils.GetOrgTlName(resource_organization_id)
128: INTO l_name
129: from pa_resources_denorm
130: WHERE resource_Id = p_resource_id
131: AND rownum = 1

Line 155: SELECT pa_expenditures_utils.GetOrgTlName(resource_organization_id)

151: ELSIF p_start_date IS NOT NULL THEN
152:
153: BEGIN
154:
155: SELECT pa_expenditures_utils.GetOrgTlName(resource_organization_id)
156: INTO l_name
157: FROM pa_resources_denorm
158: WHERE resource_Id = p_resource_id
159: AND rownum = 1