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 5043: l_project_name pa_projects_all.name%type;

5039:
5040: FUNCTION GET_PROJECT_NAME (p_wc_id IN NUMBER)
5041: RETURN VARCHAR2 IS
5042: l_count number;
5043: l_project_name pa_projects_all.name%type;
5044: begin
5045:
5046: select count(*)
5047: into l_count

Line 5048: from pa_projects_all pa,

5044: begin
5045:
5046: select count(*)
5047: into l_count
5048: from pa_projects_all pa,
5049: po_distributions_all pod
5050: where pod.project_id = pa.project_id and
5051: pod.po_distribution_id = p_wc_id;
5052:

Line 5060: from pa_projects_all pa,

5056: else
5057:
5058: select pa.name
5059: into l_project_name
5060: from pa_projects_all pa,
5061: po_distributions_all pod
5062: where pod.project_id = pa.project_id and
5063: pod.po_distribution_id = p_wc_id;
5064: