eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CREDIT_USAGES_CASCADE_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 102: hz_cust_profile_amts ca

98: INTO
99: l_cust_account_id
100: , l_site_use_id
101: FROM
102: hz_cust_profile_amts ca
103: WHERE ca.cust_acct_profile_amt_id = p_cust_acct_profile_amt_id;
104:
105: --Use the IDs to determine the entity.
106: --Note that a party level profile will have a cust_account_id of -1

Line 130: hz_cust_profile_amts ca

126: l_cust_account_id
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;

Line 414: , hz_cust_profile_amts cpa

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
418: AND cp.site_use_id = p_entity_id

Line 444: , hz_cust_profile_amts cpa

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
448: AND cp.site_use_id = p_entity_id

Line 473: , hz_cust_profile_amts cpa

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
477: AND cp.site_use_id = p_entity_id

Line 503: , hz_cust_profile_amts cpa

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
507: AND cp.site_use_id = p_entity_id

Line 533: , hz_cust_profile_amts cpa

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
537: AND cp.site_use_id IS NULL

Line 563: , hz_cust_profile_amts cpa

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
567: AND cp.site_use_id IS NULL

Line 593: , hz_cust_profile_amts cpa

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
597: AND cp.site_use_id IS NULL

Line 624: , hz_cust_profile_amts cpa

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
628: AND cp.site_use_id IS NULL

Line 646: , hz_cust_profile_amts cpa

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
650: AND cp.site_use_id IS NULL

Line 677: , hz_cust_profile_amts cpa

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
681: AND cp.site_use_id IS NULL

Line 708: , hz_cust_profile_amts cpa

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
712: AND cp.site_use_id IS NULL

Line 740: , hz_cust_profile_amts cpa

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
744: AND cp.site_use_id IS NULL