APPS.EAM_WORKORDERBILLING_PVT dependencies on HZ_CUST_ACCOUNTS

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

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

Line 121: from hz_cust_accounts

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

Line 180: from hz_cust_accounts

176: -- get term id
177: begin
178: select nvl(payment_term_id, 4)
179: into l_term_id
180: from hz_cust_accounts
181: where cust_account_id = p_ra_line.customer_id;
182:
183: exception
184: when others then