DBA Data[Home] [Help]

APPS.POS_WCAPPROVE_PVT dependencies on GMS_AWARD_DISTRIBUTIONS

Line 5251: gms_award_distributions adl,

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
5255: and adl.po_distribution_id =pod.po_distribution_id

Line 5265: gms_award_distributions adl,

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
5269: and adl.po_distribution_id =pod.po_distribution_id