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_CREDIT_USAGE_RULES

Line 183: FROM hz_credit_usage_rules

179: LOOP
180: BEGIN
181: SELECT credit_usage_rule_id
182: INTO l_id
183: FROM hz_credit_usage_rules
184: WHERE credit_usage_rule_set_id
185: = rule_set_csr_rec.credit_usage_rule_set_id
186: AND user_code IS NULL;
187:

Line 398: FROM HZ_CREDIT_USAGE_RULES

394: -------------------------
395:
396: CURSOR SELECT_USAGE_CURR_CSR IS
397: SELECT user_code
398: FROM HZ_CREDIT_USAGE_RULES
399: WHERE credit_usage_rule_set_id = p_rule_set_id
400: AND usage_type = 'CURRENCY'
401: AND NVL (include_all_flag, 'N') = 'N'
402: AND NVL(exclude_flag,'N') = 'N' ;

Line 416: , hz_credit_usage_rules cur

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
419: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
420: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 429: hz_credit_usage_rules cr2

425: AND NVL (cur.include_all_flag, 'N') = 'N'
426: AND cur.usage_type = 'CURRENCY'
427: AND cur.user_code IN (
428: SELECT cr2.user_code from
429: hz_credit_usage_rules cr2
430: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
431: AND cr2.usage_type = 'CURRENCY' and
432: NVL (cr2.include_all_flag, 'N') = 'N'
433: AND NVL(cr2.exclude_flag,'N') = 'N'

Line 446: , hz_credit_usage_rules cur

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
449: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
450: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 457: FROM hz_credit_usage_rules cur2

453: AND NVL(TRUNC(cpa.expiration_date), TRUNC(SYSDATE)
454: ) <= TRUNC(SYSDATE)
455: AND NVL (cur.include_all_flag, 'N') = 'Y'
456: AND NOT EXISTS ( SELECT 'EXCLUDE'
457: FROM hz_credit_usage_rules cur2
458: WHERE cu.credit_usage_rule_set_id
459: = cur2.credit_usage_rule_set_id
460: AND NVL(cur2.exclude_flag,'N') = 'Y'
461: AND cur2.usage_type = 'CURRENCY'

Line 475: , hz_credit_usage_rules cur

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
478: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
479: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 488: hz_credit_usage_rules cr2

484: AND NVL (cur.include_all_flag, 'N') = 'N'
485: AND cur.usage_type = 'CURRENCY'
486: AND cur.user_code NOT IN (
487: SELECT cr2.user_code from
488: hz_credit_usage_rules cr2
489: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
490: AND cr2.usage_type = 'CURRENCY' and
491: NVL (cr2.include_all_flag, 'N') = 'N'
492: AND NVL(cr2.exclude_flag,'N') = 'Y'

Line 505: , hz_credit_usage_rules cur

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
508: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
509: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 535: , hz_credit_usage_rules cur

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
538: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
539: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 548: hz_credit_usage_rules cr2

544: AND NVL (cur.include_all_flag, 'N') = 'N'
545: AND cur.usage_type = 'CURRENCY'
546: AND cur.user_code IN (
547: SELECT cr2.user_code from
548: hz_credit_usage_rules cr2
549: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
550: AND cr2.usage_type = 'CURRENCY' and
551: NVL (cr2.include_all_flag, 'N') = 'N'
552: AND NVL(cr2.exclude_flag,'N') = 'N'

Line 565: , hz_credit_usage_rules cur

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
568: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
569: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 576: FROM hz_credit_usage_rules cur2

572: AND NVL(TRUNC(cpa.expiration_date), TRUNC(SYSDATE)
573: ) <= TRUNC(SYSDATE)
574: AND NVL (cur.include_all_flag, 'N') = 'Y'
575: AND NOT EXISTS ( SELECT 'EXCLUDE'
576: FROM hz_credit_usage_rules cur2
577: WHERE cu.credit_usage_rule_set_id
578: = cur2.credit_usage_rule_set_id
579: AND NVL(cur2.exclude_flag,'N') = 'Y'
580: AND cur2.usage_type = 'CURRENCY'

Line 595: , hz_credit_usage_rules cur

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
598: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
599: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 608: hz_credit_usage_rules cr2

604: AND NVL (cur.include_all_flag, 'N') = 'N'
605: AND cur.usage_type = 'CURRENCY'
606: AND cur.user_code NOT IN (
607: SELECT cr2.user_code from
608: hz_credit_usage_rules cr2
609: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
610: AND cr2.usage_type = 'CURRENCY' and
611: NVL (cr2.include_all_flag, 'N') = 'N'
612: AND NVL(cr2.exclude_flag,'N') = 'Y'

Line 626: , hz_credit_usage_rules cur

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
629: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
630: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 648: , hz_credit_usage_rules cur

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
651: AND cp.party_id = p_entity_id
652: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 662: hz_credit_usage_rules cr2

658: AND NVL (cur.include_all_flag, 'N') = 'N'
659: AND cur.usage_type = 'CURRENCY'
660: AND cur.user_code IN (
661: SELECT cr2.user_code from
662: hz_credit_usage_rules cr2
663: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
664: AND cr2.usage_type = 'CURRENCY' and
665: NVL (cr2.include_all_flag, 'N') = 'N'
666: AND NVL(cr2.exclude_flag,'N') = 'N'

Line 679: , hz_credit_usage_rules cur

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
682: AND cp.party_id = p_entity_id
683: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 691: FROM hz_credit_usage_rules cur2

687: AND NVL(TRUNC(cpa.expiration_date), TRUNC(SYSDATE)
688: ) <= TRUNC(SYSDATE)
689: AND NVL (cur.include_all_flag, 'N') = 'Y'
690: AND NOT EXISTS ( SELECT 'EXCLUDE'
691: FROM hz_credit_usage_rules cur2
692: WHERE cu.credit_usage_rule_set_id
693: = cur2.credit_usage_rule_set_id
694: AND NVL(cur2.exclude_flag,'N') = 'Y'
695: AND cur2.usage_type = 'CURRENCY'

Line 710: , hz_credit_usage_rules cur

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
713: AND cp.party_id = p_entity_id
714: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 724: hz_credit_usage_rules cr2

720: AND NVL (cur.include_all_flag, 'N') = 'N'
721: AND cur.usage_type = 'CURRENCY'
722: AND cur.user_code NOT IN (
723: SELECT cr2.user_code from
724: hz_credit_usage_rules cr2
725: WHERE cr2.credit_usage_rule_set_id = p_rule_set_id
726: AND cr2.usage_type = 'CURRENCY' and
727: NVL (cr2.include_all_flag, 'N') = 'N'
728: AND NVL(cr2.exclude_flag,'N') = 'Y'

Line 742: , hz_credit_usage_rules cur

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
745: AND cp.party_id = p_entity_id
746: AND cp.cust_account_profile_id = cpa.cust_account_profile_id