APPS.QP_SOURCING_API_PUB dependencies on HZ_CUST_ACCOUNTS

Line 39: -- Getting info from HZ_CUST_ACCOUNTS

35: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
36:
37: G_Customer_Info.customer_id := p_cust_id;
38:
39: -- Getting info from HZ_CUST_ACCOUNTS
40: BEGIN
41: SELECT customer_class_code, sales_channel_code
42: INTO G_Customer_Info.customer_class_code, G_Customer_Info.sales_channel_code
43: FROM hz_cust_accounts

Line 43: FROM hz_cust_accounts

39: -- Getting info from HZ_CUST_ACCOUNTS
40: BEGIN
41: SELECT customer_class_code, sales_channel_code
42: INTO G_Customer_Info.customer_class_code, G_Customer_Info.sales_channel_code
43: FROM hz_cust_accounts
44: WHERE cust_account_id = p_cust_id;
45:
46: EXCEPTION
47: WHEN no_data_found THEN

Line 91: from hz_parties hp,hz_cust_accounts hca

87:
88: IF( G_Customer_Info.gsa_indicator is null) THEN
89: SELECT NVL(gsa_indicator_flag,'N')
90: into G_Customer_Info.gsa_indicator
91: from hz_parties hp,hz_cust_accounts hca
92: where hp.party_id = hca.party_id
93: and hca.cust_account_id = p_cust_id ;
94:
95: G_GSA_INDICATOR_FLAGS(p_cust_id) := G_Customer_Info.gsa_indicator;

Line 1302: FROM hz_cust_accounts

1298: l_party_id NUMBER;
1299:
1300: CURSOR get_party_id_cur(l_sold_to_org_id NUMBER) IS
1301: SELECT party_id
1302: FROM hz_cust_accounts
1303: WHERE cust_account_id = l_sold_to_org_id;
1304:
1305: BEGIN
1306: OPEN get_party_id_cur(p_sold_to_org_id);

Line 1632: -- Getting info from HZ_CUST_ACCOUNTS

1628: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1629:
1630: G_Customer_Info.customer_id := p_cust_id;
1631:
1632: -- Getting info from HZ_CUST_ACCOUNTS
1633:
1634: BEGIN
1635: SELECT customer_class_code, sales_channel_code
1636: INTO G_Customer_Info.customer_class_code, G_Customer_Info.sales_channel_code

Line 1637: FROM hz_cust_accounts

1633:
1634: BEGIN
1635: SELECT customer_class_code, sales_channel_code
1636: INTO G_Customer_Info.customer_class_code, G_Customer_Info.sales_channel_code
1637: FROM hz_cust_accounts
1638: WHERE cust_account_id = p_cust_id;
1639:
1640: EXCEPTION
1641: WHEN no_data_found THEN

Line 1677: from hz_parties hp,hz_cust_accounts hca

1673: BEGIN
1674:
1675: SELECT NVL(gsa_indicator_flag,'N')
1676: into G_Customer_Info.gsa_indicator
1677: from hz_parties hp,hz_cust_accounts hca
1678: where hp.party_id = hca.party_id
1679: and hca.cust_account_id = p_cust_id ;
1680:
1681: EXCEPTION