APPS.EAM_WORKORDERBILLING_PVT dependencies on HZ_CUST_ACCOUNTS

Line 124: -- validation 2: customer chosen should exist in the table 'hz_cust_accounts'.

120: EFFECT : EAM WILL NOT CHECK IF THE 'REQUIRE SALESREP 'OPTION IS SET TO YES/NO
121: */
122:
123:
124: -- validation 2: customer chosen should exist in the table 'hz_cust_accounts'.
125: select count(*) into l_count
126: from hz_cust_accounts
127: where cust_account_id=p_ra_line.customer_id;
128:

Line 126: from hz_cust_accounts

122:
123:
124: -- validation 2: customer chosen should exist in the table 'hz_cust_accounts'.
125: select count(*) into l_count
126: from hz_cust_accounts
127: where cust_account_id=p_ra_line.customer_id;
128:
129: if (l_count=0) then
130: FND_MESSAGE.SET_NAME('EAM', 'EAM_CUSTOMER_NOT_EXIST');

Line 192: HZ_CUST_ACCOUNTS CUST_ACCT

188: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
189: HZ_PARTY_SITES PARTY_SITE,
190: HZ_LOCATIONS LOC,
191: HZ_CUST_SITE_USES_ALL SITE,
192: HZ_CUST_ACCOUNTS CUST_ACCT
193: WHERE
194: site.site_use_code = 'BILL_TO'
195: and site.status='A'
196: and site.cust_acct_site_id = acct_site.cust_acct_site_id

Line 293: from hz_cust_accounts hca,

289: -- Added for bug 6037087
290: begin
291: select rt.name
292: into l_term_name
293: from hz_cust_accounts hca,
294: ra_terms rt
295: where nvl(hca.payment_term_id,4) = rt.term_id
296: and cust_account_id = p_ra_line.customer_id;
297: