APPS.HZP_CUST_PKG dependencies on HZ_CUST_ACCOUNTS

Line 90: from hz_cust_accounts

86: select 1
87: into dummy
88: from dual
89: where not exists ( select 1
90: from hz_cust_accounts
91: where account_number = p_customer_number
92: and ( ( p_rowid is null ) or (rowid <> p_rowid))
93: );
94:

Line 178: from hz_cust_accounts c

174: select 1
175: into dummy
176: from dual
177: where not exists ( select 1
178: from hz_cust_accounts c
179: where c.orig_system_reference = p_orig_system_reference
180: and ( ( p_rowid is null ) or (c.rowid <> p_rowid)));
181:
182: exception

Line 220: FROM hz_cust_accounts

216: l_status VARCHAR2(1);
217: l_lock_status NUMBER;
218: CURSOR statuscur IS
219: SELECT status
220: FROM hz_cust_accounts
221: WHERE rowid = p_rowid;
222:
223: BEGIN
224: -- bug 2092530: removed the check to the ar_alt_name_search profile

Line 281: | ARP_CUST_PKG.get_statement_site(hz_cust_accounts.cust_account_id) = |

277: | ra customers.statement_site_use_id = hz_cust_site_uses.site_use_id (+) |
278: | |
279: | These queries can now be changed to: |
280: | |
281: | ARP_CUST_PKG.get_statement_site(hz_cust_accounts.cust_account_id) = |
282: | hz_cust_site_uses.site_use_id (+) |
283: | |
284: | Make sure you donot pass a constant as an argument when making use |
285: | of this function in a query which is supposed to succeed even if the |

Line 299: p_customer_id IN hz_cust_accounts.cust_account_id%type

295: | and replaced with hz counterparts |
296: +===========================================================================*/
297:
298: FUNCTION get_statement_site (
299: p_customer_id IN hz_cust_accounts.cust_account_id%type
300: )
301: RETURN NUMBER is
302:
303: v_statement_site_use_id hz_cust_site_uses.site_use_id%type;

Line 361: | ARP_CUST_PKG.get_dunning(hz_cust_accounts.cust_account_id) = |

357: | ra customers.dunning_site_use_id = hz_cust_site_uses.site_use_id (+) |
358: | |
359: | These queries can now be changed to: |
360: | |
361: | ARP_CUST_PKG.get_dunning(hz_cust_accounts.cust_account_id) = |
362: | hz_cust_site_uses.site_use_id (+) |
363: | |
364: | Make sure you donot pass a constant as an argument when making use |
365: | of this function in a query which is supposed to succeed even if the |

Line 379: p_customer_id IN hz_cust_accounts.cust_account_id%type

375: | and replaced with hz counterparts |
376: +===========================================================================*/
377:
378: FUNCTION get_dunning_site (
379: p_customer_id IN hz_cust_accounts.cust_account_id%type
380: )
381: RETURN NUMBER is
382:
383: v_dunning_site_use_id hz_cust_site_uses.site_use_id%type;

Line 440: p_customer_id IN hz_cust_accounts.cust_account_id%type,

436: | |
437: +===========================================================================+*/
438: --
439: FUNCTION get_current_dunning_type (
440: p_customer_id IN hz_cust_accounts.cust_account_id%type,
441: p_bill_to_site_id IN NUMBER
442: )
443: return varchar2 is
444: --

Line 471: hz_cust_accounts cus

467: hz_cust_acct_sites ad_cus,
468: hz_customer_profiles cust_pro,
469: hz_customer_profiles site_pro,
470: ar_dunning_letter_sets dls,
471: hz_cust_accounts cus
472: where su.site_use_code = 'BILL_TO'
473: and su.status = 'A'
474: and su.site_use_id = p_bill_to_site_id
475: and ad_cus.cust_acct_site_id = su.cust_acct_site_id

Line 548: p_customer_id IN hz_cust_accounts.cust_account_id%type

544: END;
545:
546: --
547: FUNCTION get_primary_billto_site (
548: p_customer_id IN hz_cust_accounts.cust_account_id%type
549: )
550: RETURN NUMBER is
551:
552: v_billto_site_use_id hz_cust_site_uses.site_use_id%type;