APPS.HZ_CREDIT_USAGES_CASCADE_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 131: , hz_customer_profiles cp

127: , l_site_use_id
128: , l_party_id
129: FROM
130: hz_cust_profile_amts ca
131: , hz_customer_profiles cp
132: WHERE ca.cust_acct_profile_amt_id = p_cust_acct_profile_amt_id
133: AND ca.CUST_ACCOUNT_PROFILE_ID = cp.CUST_ACCOUNT_PROFILE_ID
134: AND cp.cust_account_id = -1;
135: IF l_party_id is not NULL

Line 413: FROM hz_customer_profiles cp

409: CURSOR site_check_case1_no_incl_csr IS
410: SELECT cu.credit_usage_id
411: , substrb(cur.user_code,1,5) curr
412: , cpa.currency_code prof_curr
413: FROM hz_customer_profiles cp
414: , hz_cust_profile_amts cpa
415: , hz_credit_usages cu
416: , hz_credit_usage_rules cur
417: WHERE cp.cust_account_id = p_cust_account_id

Line 443: FROM hz_customer_profiles cp

439:
440: CURSOR site_check_case1_incl_csr ( p_curr_code IN VARCHAR2 ) IS
441: SELECT cpa.currency_code profile_curr
442: , cu.credit_usage_id
443: FROM hz_customer_profiles cp
444: , hz_cust_profile_amts cpa
445: , hz_credit_usages cu
446: , hz_credit_usage_rules cur
447: WHERE cp.cust_account_id = p_cust_account_id

Line 472: FROM hz_customer_profiles cp

468: CURSOR site_check_case2_no_incl_csr IS
469: SELECT cu.credit_usage_id
470: , substrb(cur.user_code,1,5) curr
471: , cpa.currency_code prof_curr
472: FROM hz_customer_profiles cp
473: , hz_cust_profile_amts cpa
474: , hz_credit_usages cu
475: , hz_credit_usage_rules cur
476: WHERE cp.cust_account_id = p_cust_account_id

Line 502: FROM hz_customer_profiles cp

498:
499: CURSOR site_check_case2_incl_csr IS
500: SELECT cpa.currency_code profile_curr
501: , cu.credit_usage_id
502: FROM hz_customer_profiles cp
503: , hz_cust_profile_amts cpa
504: , hz_credit_usages cu
505: , hz_credit_usage_rules cur
506: WHERE cp.cust_account_id = p_cust_account_id

Line 532: FROM hz_customer_profiles cp

528: CURSOR cust_check_case1_no_incl_csr IS
529: SELECT cu.credit_usage_id
530: , substrb(cur.user_code,1,5) curr
531: , cpa.currency_code prof_curr
532: FROM hz_customer_profiles cp
533: , hz_cust_profile_amts cpa
534: , hz_credit_usages cu
535: , hz_credit_usage_rules cur
536: WHERE cp.cust_account_id = p_entity_id

Line 562: FROM hz_customer_profiles cp

558:
559: CURSOR cust_check_case1_incl_csr ( p_curr_code IN VARCHAR2 ) IS
560: SELECT cpa.currency_code profile_curr
561: , cu.credit_usage_id
562: FROM hz_customer_profiles cp
563: , hz_cust_profile_amts cpa
564: , hz_credit_usages cu
565: , hz_credit_usage_rules cur
566: WHERE cp.cust_account_id = p_entity_id

Line 592: FROM hz_customer_profiles cp

588: CURSOR cust_check_case2_no_incl_csr IS
589: SELECT cu.credit_usage_id
590: , substrb(cur.user_code,1,5) curr
591: , cpa.currency_code prof_curr
592: FROM hz_customer_profiles cp
593: , hz_cust_profile_amts cpa
594: , hz_credit_usages cu
595: , hz_credit_usage_rules cur
596: WHERE cp.cust_account_id = p_entity_id

Line 623: FROM hz_customer_profiles cp

619:
620: CURSOR cust_check_case2_incl_csr IS
621: SELECT cpa.currency_code profile_curr
622: , cu.credit_usage_id
623: FROM hz_customer_profiles cp
624: , hz_cust_profile_amts cpa
625: , hz_credit_usages cu
626: , hz_credit_usage_rules cur
627: WHERE cp.cust_account_id = p_entity_id

Line 645: FROM hz_customer_profiles cp

641: CURSOR party_check_case1_no_incl_csr IS
642: SELECT cu.credit_usage_id
643: , substrb(cur.user_code,1,5) curr
644: , cpa.currency_code prof_curr
645: FROM hz_customer_profiles cp
646: , hz_cust_profile_amts cpa
647: , hz_credit_usages cu
648: , hz_credit_usage_rules cur
649: WHERE cp.cust_account_id = -1

Line 676: FROM hz_customer_profiles cp

672:
673: CURSOR party_check_case1_incl_csr ( p_curr_code IN VARCHAR2 ) IS
674: SELECT cpa.currency_code profile_curr
675: , cu.credit_usage_id
676: FROM hz_customer_profiles cp
677: , hz_cust_profile_amts cpa
678: , hz_credit_usages cu
679: , hz_credit_usage_rules cur
680: WHERE cp.cust_account_id = -1

Line 707: FROM hz_customer_profiles cp

703: CURSOR party_check_case2_no_incl_csr IS
704: SELECT cu.credit_usage_id
705: , substrb(cur.user_code,1,5) curr
706: , cpa.currency_code prof_curr
707: FROM hz_customer_profiles cp
708: , hz_cust_profile_amts cpa
709: , hz_credit_usages cu
710: , hz_credit_usage_rules cur
711: WHERE cp.cust_account_id = -1

Line 739: FROM hz_customer_profiles cp

735:
736: CURSOR party_check_case2_incl_csr IS
737: SELECT cpa.currency_code profile_curr
738: , cu.credit_usage_id
739: FROM hz_customer_profiles cp
740: , hz_cust_profile_amts cpa
741: , hz_credit_usages cu
742: , hz_credit_usage_rules cur
743: WHERE cp.cust_account_id = -1