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 GMS_AWARDS_ALL

Line 5245: l_award_number gms_awards_all.award_number%type;

5241:
5242: FUNCTION GET_AWARD_NUM (p_wc_id IN NUMBER)
5243: RETURN VARCHAR2 IS
5244: l_count number;
5245: l_award_number gms_awards_all.award_number%type;
5246: begin
5247:
5248: select count(*)
5249: into l_count

Line 5250: from gms_awards_all awd,

5246: begin
5247:
5248: select count(*)
5249: into l_count
5250: from gms_awards_all awd,
5251: gms_award_distributions adl,
5252: po_distributions_all pod
5253: where adl.award_id = awd.award_id
5254: and adl.adl_line_num = 1

Line 5264: from gms_awards_all awd,

5260: return to_char(null);
5261: else
5262: select awd.award_number
5263: into l_award_number
5264: from gms_awards_all awd,
5265: gms_award_distributions adl,
5266: po_distributions_all pod
5267: where adl.award_id = awd.award_id
5268: and adl.adl_line_num = 1