APPS.XNB_BILL_SUMMARIES_PKG dependencies on HZ_CUST_ACCOUNTS

Line 28: -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER.

24: -- . XNB_BILL_SUMMARIES
25: -- Assumptions :
26: -- All records whose
27: -- 1. Account Number must exit in eBusiness suite database schema
28: -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER.
29: -- 2. Account Number, Bill Number, Bill Cycle End Date and Billing
30: -- Vendor Name are required.
31: -- 3. Bill Number, Account Number and Billing Vendor Name combined
32: -- must be unique for insertion.

Line 124: from HZ_CUST_ACCOUNTS

120: l_attribute15 v_var150;
121:
122: Cursor c_get_acc_num is
123: select ACCOUNT_NUMBER
124: from HZ_CUST_ACCOUNTS
125: where ACCOUNT_NUMBER = tmp_acc_num;
126:
127: Cursor c_check_uniq_constrain is
128: select 1

Line 265: -- Fetch account number from HZ_CUST_ACCOUNTS table

261: ELSE
262: tmp_acc_num := p_bill_summaries(i).ACCOUNT_NUMBER;
263: tmp_acc_num2 := null;
264:
265: -- Fetch account number from HZ_CUST_ACCOUNTS table
266: open c_get_acc_num;
267: begin
268: fetch c_get_acc_num into tmp_acc_num2;
269: if (c_get_acc_num%NOTFOUND OR tmp_acc_num2 IS NULL) then

Line 519: -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER.

515: -- . XNB_BILL_SUMMARIES.
516: -- Assumptions :
517: -- All records whose
518: -- 1. Account Number must exit in eBusiness suite database schema
519: -- HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER.
520: -- 2. Account Number, Bill Number, Bill Cycle End Date and Billing
521: -- Vendor Name are required.
522: -- 3. Account Number, Bill Number and Billing Vendor Name cannot be
523: -- updated and hence must be present for updating.