DBA Data[Home] [Help]

APPS.GMS_WF_PKG dependencies on GMS_REPORTS

Line 2216: from gms_awards_v ga, gms_installments gi, gms_reports_v grv

2212: grv.report_name,
2213: grv.due_date,
2214: ga.funding_source_short_name,
2215: grv.report_id --bug 2282107
2216: from gms_awards_v ga, gms_installments gi, gms_reports_v grv
2217: where grv.installment_id = gi.installment_id
2218: and gi.award_id = ga.award_id
2219: and grv.due_date = trunc(sysdate) + l_offset_days -- Bug 1868293
2220: and ga.status <> 'CLOSED' --Changed from 'ACTIVE' to fix bug 2200837

Line 2236: gms_reports gr,

2232: substrb(party.party_name,1,50) funding_source_short_name,
2233: gr.report_id --bug 2282107
2234: from gms_awards ga,
2235: gms_installments gi,
2236: gms_reports gr,
2237: gms_report_templates grt,
2238: hz_parties party,
2239: hz_cust_accounts cust_acct
2240: where ga.award_template_flag ='DEFERRED'