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 4918: l_award_number gms_awards_all.award_number%type;

4914:
4915: FUNCTION GET_AWARD_NUM (p_wc_id IN NUMBER)
4916: RETURN VARCHAR2 IS
4917: l_count number;
4918: l_award_number gms_awards_all.award_number%type;
4919: begin
4920:
4921: select count(*)
4922: into l_count

Line 4923: from gms_awards_all awd,

4919: begin
4920:
4921: select count(*)
4922: into l_count
4923: from gms_awards_all awd,
4924: gms_award_distributions adl,
4925: po_distributions_all pod
4926: where adl.award_id = awd.award_id
4927: and adl.adl_line_num = 1

Line 4937: from gms_awards_all awd,

4933: return to_char(null);
4934: else
4935: select awd.award_number
4936: into l_award_number
4937: from gms_awards_all awd,
4938: gms_award_distributions adl,
4939: po_distributions_all pod
4940: where adl.award_id = awd.award_id
4941: and adl.adl_line_num = 1