APPS.JAI_CREDIT_CHECK_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 57: select HZ_CUSTOMER_PROFILES.credit_checking

53:
54: --Cusor which is used to validate Credit Check whether be enabled on customer site level
55: CURSOR chk_credit_check_site
56: IS
57: select HZ_CUSTOMER_PROFILES.credit_checking
58: from HZ_CUST_SITE_USES_all,
59: hz_cust_acct_sites_all,
60: HZ_CUSTOMER_PROFILES
61: where hz_cust_acct_sites_all.cust_acct_site_id = HZ_CUST_SITE_USES_all.cust_acct_site_id

Line 60: HZ_CUSTOMER_PROFILES

56: IS
57: select HZ_CUSTOMER_PROFILES.credit_checking
58: from HZ_CUST_SITE_USES_all,
59: hz_cust_acct_sites_all,
60: HZ_CUSTOMER_PROFILES
61: where hz_cust_acct_sites_all.cust_acct_site_id = HZ_CUST_SITE_USES_all.cust_acct_site_id
62: and hz_cust_acct_sites_all.cust_account_id = pn_cust_account_id
63: and HZ_CUST_SITE_USES_all.site_use_code = 'BILL_TO'
64: and HZ_CUST_SITE_USES_all.site_use_id = HZ_CUSTOMER_PROFILES.site_use_id

Line 64: and HZ_CUST_SITE_USES_all.site_use_id = HZ_CUSTOMER_PROFILES.site_use_id

60: HZ_CUSTOMER_PROFILES
61: where hz_cust_acct_sites_all.cust_acct_site_id = HZ_CUST_SITE_USES_all.cust_acct_site_id
62: and hz_cust_acct_sites_all.cust_account_id = pn_cust_account_id
63: and HZ_CUST_SITE_USES_all.site_use_code = 'BILL_TO'
64: and HZ_CUST_SITE_USES_all.site_use_id = HZ_CUSTOMER_PROFILES.site_use_id
65: and HZ_CUST_SITE_USES_all.site_use_id = pn_site_use_id;
66:
67: --Cursor is used to validate the Credit Check whether be enabled on customer accounting level
68: CURSOR chk_credit_check_account

Line 70: select HZ_CUSTOMER_PROFILES.credit_checking

66:
67: --Cursor is used to validate the Credit Check whether be enabled on customer accounting level
68: CURSOR chk_credit_check_account
69: IS
70: select HZ_CUSTOMER_PROFILES.credit_checking
71: from HZ_CUSTOMER_PROFILES
72: where HZ_CUSTOMER_PROFILES.cust_account_id = pn_cust_account_id
73: and HZ_CUSTOMER_PROFILES.site_use_id is NULL;
74:

Line 71: from HZ_CUSTOMER_PROFILES

67: --Cursor is used to validate the Credit Check whether be enabled on customer accounting level
68: CURSOR chk_credit_check_account
69: IS
70: select HZ_CUSTOMER_PROFILES.credit_checking
71: from HZ_CUSTOMER_PROFILES
72: where HZ_CUSTOMER_PROFILES.cust_account_id = pn_cust_account_id
73: and HZ_CUSTOMER_PROFILES.site_use_id is NULL;
74:
75: -- variable block

Line 72: where HZ_CUSTOMER_PROFILES.cust_account_id = pn_cust_account_id

68: CURSOR chk_credit_check_account
69: IS
70: select HZ_CUSTOMER_PROFILES.credit_checking
71: from HZ_CUSTOMER_PROFILES
72: where HZ_CUSTOMER_PROFILES.cust_account_id = pn_cust_account_id
73: and HZ_CUSTOMER_PROFILES.site_use_id is NULL;
74:
75: -- variable block
76: lv_credit_check HZ_CUSTOMER_PROFILES.credit_checking%TYPE;

Line 73: and HZ_CUSTOMER_PROFILES.site_use_id is NULL;

69: IS
70: select HZ_CUSTOMER_PROFILES.credit_checking
71: from HZ_CUSTOMER_PROFILES
72: where HZ_CUSTOMER_PROFILES.cust_account_id = pn_cust_account_id
73: and HZ_CUSTOMER_PROFILES.site_use_id is NULL;
74:
75: -- variable block
76: lv_credit_check HZ_CUSTOMER_PROFILES.credit_checking%TYPE;
77:

Line 76: lv_credit_check HZ_CUSTOMER_PROFILES.credit_checking%TYPE;

72: where HZ_CUSTOMER_PROFILES.cust_account_id = pn_cust_account_id
73: and HZ_CUSTOMER_PROFILES.site_use_id is NULL;
74:
75: -- variable block
76: lv_credit_check HZ_CUSTOMER_PROFILES.credit_checking%TYPE;
77:
78: BEGIN
79: --Firstly, check the available of Credit check on customer site level
80: OPEN chk_credit_check_site;