APPS.JAI_CREDIT_CHECK_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 58: from HZ_CUST_SITE_USES_all,

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
62: and hz_cust_acct_sites_all.cust_account_id = pn_cust_account_id

Line 61: where hz_cust_acct_sites_all.cust_acct_site_id = HZ_CUST_SITE_USES_all.cust_acct_site_id

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
65: and HZ_CUST_SITE_USES_all.site_use_id = pn_site_use_id;

Line 63: and HZ_CUST_SITE_USES_all.site_use_code = 'BILL_TO'

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
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

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 65: and HZ_CUST_SITE_USES_all.site_use_id = pn_site_use_id;

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
69: IS