APPS.OKC_XPRT_QUOTE_INT_PVT dependencies on HZ_PARTIES

Line 89: l_party_id HZ_PARTIES.party_id%type;

85: l_api_name VARCHAR2(30) := 'get_clause_variable_values';
86: l_package_procedure VARCHAR2(60);
87: l_api_version CONSTANT NUMBER := 1;
88: l_debug Boolean;
89: l_party_id HZ_PARTIES.party_id%type;
90: l_module VARCHAR2(250) := G_MODULE_NAME||l_api_name;
91: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;
92: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;
93:

Line 176: hz_parties hzp

172: hzcp.risk_code
173: FROM
174: hz_customer_profiles hzcp,
175: hz_cust_accounts hzc,
176: hz_parties hzp
177: WHERE
178: hzc.cust_account_id = hzcp.cust_account_id
179: AND hzcp.site_use_id is null
180: AND hzc.party_id = hzcp.party_id

Line 216: l_customer_category hz_parties.category_code%TYPE;

212: pc.agreement_id = p_agreement_id;
213:
214: l_quote_header_variables c_get_quote_header_variables%ROWTYPE;
215: l_cust_info_variables c_get_cust_info_var%ROWTYPE;
216: l_customer_category hz_parties.category_code%TYPE;
217:
218:
219: BEGIN
220:

Line 334: FROM hz_parties

330: ELSE -- Customer Category is the only variable considered for prospects
331: BEGIN
332: SELECT category_code
333: INTO l_customer_category
334: FROM hz_parties
335: WHERE party_id = l_quote_header_variables.party_id;
336: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,'360: category_code = '||l_customer_category );
338: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,l_module,' ');