DBA Data[Home] [Help]

APPS.GMS_WF_PKG dependencies on HZ_CUST_ACCOUNTS

Line 2239: hz_cust_accounts cust_acct

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'
2241: and ga.status <> 'CLOSED' --Changed from 'ACTIVE' to fix bug 2200837
2242: and ga.award_id = gi.award_id
2243: and gi.active_flag = 'Y'

Line 2623: hz_cust_accounts cust_acct

2619: (nvl(gi.direct_cost,0) + nvl(gi.indirect_cost,0)),
2620: gi.description
2621: from gms_awards ga,
2622: gms_installments gi, hz_parties party,
2623: hz_cust_accounts cust_acct
2624: where gi.award_id = ga.award_id
2625: and cust_acct.cust_account_id(+) = ga.funding_source_id
2626: and cust_acct.party_id = party.party_id
2627: and gi.installment_id = x_install_id