APPS.AR_RAXSKI_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 134: from hz_cust_accounts

130: inactive_count_change_t VARCHAR2(10);
131: begin
132: select count(*)
133: into v_customers_t
134: from hz_cust_accounts
135: where creation_date between p_start_date
136: and p_end_date + (86399/86400);
137:
138:

Line 141: from hz_cust_accounts

137:
138:
139: select count(*)
140: into prior_v_customers_t
141: from hz_cust_accounts
142: where creation_date between p_prior_start_date
143: and p_prior_end_date + (86399/86400);
144:
145:

Line 150: from hz_cust_accounts;

146: select count(*),
147: NVL(sum(decode(status,'I',1,0)),0)
148: into cust_total_number_t,
149: inactive_count_total_number_t
150: from hz_cust_accounts;
151:
152:
153: select NVL(sum(decode(status,'I',1,0)),0)
154: into prior_v_inactive_count_t

Line 155: from hz_cust_accounts

151:
152:
153: select NVL(sum(decode(status,'I',1,0)),0)
154: into prior_v_inactive_count_t
155: from hz_cust_accounts
156: where last_update_date between
157: p_prior_start_date
158: and p_prior_end_date + (86399/86400);
159:

Line 163: from hz_cust_accounts

159:
160:
161: select NVL(sum(decode(status,'I',1,0)),0)
162: into v_inactive_count_t
163: from hz_cust_accounts
164: where last_update_date between p_start_date
165: and p_end_date + (86399/86400);
166:
167: