APPS.HZ_CREDIT_USAGES_PKG dependencies on HZ_CREDIT_USAGE_RULES

Line 307: , hz_credit_usage_rules cur

303: , cu.credit_usage_rule_set_id
304: FROM hz_customer_profiles cp
305: , hz_cust_profile_amts cpa
306: , hz_credit_usages cu
307: , hz_credit_usage_rules cur
308: WHERE cp.cust_account_id = p_entity_id
309: AND cp.site_use_id IS NULL
310: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
311: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 336: , hz_credit_usage_rules cur

332: , cu.credit_usage_rule_set_id
333: FROM hz_customer_profiles cp
334: , hz_cust_profile_amts cpa
335: , hz_credit_usages cu
336: , hz_credit_usage_rules cur
337: WHERE cp.cust_account_id = p_entity_id
338: AND cp.site_use_id IS NULL
339: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
340: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id

Line 347: FROM hz_credit_usage_rules cur2

343: ) <= TRUNC(SYSDATE)
344: AND NVL (cur.include_all_flag, 'N') = 'Y'
345: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id
346: AND NOT EXISTS ( SELECT 'EXCLUDE'
347: FROM hz_credit_usage_rules cur2
348: WHERE cu.credit_usage_rule_set_id
349: = cur2.credit_usage_rule_set_id
350: AND NVL(cur2.exclude_flag,'N') = 'Y'
351: AND cur2.usage_type = 'CURRENCY'

Line 372: , hz_credit_usage_rules cur

368: , cu.credit_usage_rule_set_id
369: FROM hz_customer_profiles cp
370: , hz_cust_profile_amts cpa
371: , hz_credit_usages cu
372: , hz_credit_usage_rules cur
373: WHERE cp.site_use_id = p_entity_id
374: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
375: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id
376: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id

Line 399: , hz_credit_usage_rules cur

395: , cu.credit_usage_rule_set_id
396: FROM hz_customer_profiles cp
397: , hz_cust_profile_amts cpa
398: , hz_credit_usages cu
399: , hz_credit_usage_rules cur
400: WHERE cp.site_use_id = p_entity_id
401: AND cp.cust_account_profile_id = cpa.cust_account_profile_id
402: AND cpa.cust_acct_profile_amt_id = cu.cust_acct_profile_amt_id
403: AND cu.credit_usage_rule_set_id = cur.credit_usage_rule_set_id

Line 408: FROM hz_credit_usage_rules cur2

404: AND NVL(TRUNC(cpa.expiration_date), TRUNC(SYSDATE)
405: ) <= TRUNC(SYSDATE)
406: AND NVL (cur.include_all_flag, 'N') = 'Y'
407: AND NOT EXISTS ( SELECT 'EXCLUDE'
408: FROM hz_credit_usage_rules cur2
409: WHERE cu.credit_usage_rule_set_id
410: = cur2.credit_usage_rule_set_id
411: AND NVL(cur2.exclude_flag,'N') = 'Y'
412: AND cur2.usage_type = 'CURRENCY'

Line 432: , hz_credit_usage_rules cur

428: , cu.credit_usage_rule_set_id
429: FROM hz_customer_profiles cp
430: , hz_cust_profile_amts cpa
431: , hz_credit_usages cu
432: , hz_credit_usage_rules cur
433: WHERE cp.cust_account_id = -1
434: AND cp.site_use_id IS NULL
435: AND cp.party_id = p_entity_id
436: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 462: , hz_credit_usage_rules cur

458: , cu.credit_usage_rule_set_id
459: FROM hz_customer_profiles cp
460: , hz_cust_profile_amts cpa
461: , hz_credit_usages cu
462: , hz_credit_usage_rules cur
463: WHERE cp.cust_account_id = -1
464: AND cp.site_use_id IS NULL
465: AND cp.party_id = p_entity_id
466: AND cp.cust_account_profile_id = cpa.cust_account_profile_id

Line 473: FROM hz_credit_usage_rules cur2

469: AND NVL(TRUNC(cpa.expiration_date), TRUNC(SYSDATE)
470: ) <= TRUNC(SYSDATE)
471: AND NVL (cur.include_all_flag, 'N') = 'Y'
472: AND NOT EXISTS ( SELECT 'EXCLUDE'
473: FROM hz_credit_usage_rules cur2
474: WHERE cu.credit_usage_rule_set_id
475: = cur2.credit_usage_rule_set_id
476: AND NVL(cur2.exclude_flag,'N') = 'Y'
477: AND cur2.usage_type = 'CURRENCY'

Line 671: FROM hz_credit_usage_rules

667: --------------------------------------------------------
668:
669: CURSOR include_all_csr (c_credit_usage_rule_set_id IN NUMBER) IS
670: SELECT 'X'
671: FROM hz_credit_usage_rules
672: WHERE credit_usage_rule_set_id = c_credit_usage_rule_set_id
673: AND usage_type = 'CURRENCY'
674: AND NVL(include_all_flag, 'N') = 'Y';
675:

Line 683: FROM hz_credit_usage_rules cur

679: --------------------------------------------------------
680:
681: CURSOR incl_curr_csr (c_credit_usage_rule_set_id IN NUMBER) IS
682: SELECT user_code
683: FROM hz_credit_usage_rules cur
684: WHERE cur.credit_usage_rule_set_id = c_credit_usage_rule_set_id
685: AND cur.usage_type = 'CURRENCY'
686: AND cur.user_code IS NOT NULL
687: AND NVL(cur.exclude_flag,'N') = 'N';

Line 696: FROM hz_credit_usage_rules cur

692: --------------------------------------------------------
693:
694: CURSOR excl_curr_csr (c_credit_usage_rule_set_id IN NUMBER) IS
695: SELECT user_code
696: FROM hz_credit_usage_rules cur
697: WHERE cur.credit_usage_rule_set_id = c_credit_usage_rule_set_id
698: AND cur.usage_type = 'CURRENCY'
699: AND cur.user_code IS NOT NULL
700: AND NVL(cur.exclude_flag,'N') = 'Y';