eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_WCAPPROVE_PVT dependencies on PA_PROJECTS_ALL

Line 5370: l_project_name pa_projects_all.name%type;

5366:
5367: FUNCTION GET_PROJECT_NAME (p_wc_id IN NUMBER)
5368: RETURN VARCHAR2 IS
5369: l_count number;
5370: l_project_name pa_projects_all.name%type;
5371: begin
5372:
5373: select count(*)
5374: into l_count

Line 5375: from pa_projects_all pa,

5371: begin
5372:
5373: select count(*)
5374: into l_count
5375: from pa_projects_all pa,
5376: po_distributions_all pod
5377: where pod.project_id = pa.project_id and
5378: pod.po_distribution_id = p_wc_id;
5379:

Line 5387: from pa_projects_all pa,

5383: else
5384:
5385: select pa.name
5386: into l_project_name
5387: from pa_projects_all pa,
5388: po_distributions_all pod
5389: where pod.project_id = pa.project_id and
5390: pod.po_distribution_id = p_wc_id;
5391: