APPS.QP_SOURCING_API_PUB dependencies on HZ_CUST_ACCOUNTS

Line 38: -- Getting info from HZ_CUST_ACCOUNTS

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

Line 42: FROM hz_cust_accounts

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

Line 90: from hz_parties hp,hz_cust_accounts hca

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

Line 1310: FROM hz_cust_accounts

1306: l_party_id NUMBER;
1307:
1308: CURSOR get_party_id_cur(l_sold_to_org_id NUMBER) IS
1309: SELECT party_id
1310: FROM hz_cust_accounts
1311: WHERE cust_account_id = l_sold_to_org_id;
1312:
1313: BEGIN
1314: OPEN get_party_id_cur(p_sold_to_org_id);

Line 1640: -- Getting info from HZ_CUST_ACCOUNTS

1636: if qp_preq_grp.g_new_pricing_call = qp_preq_grp.g_yes then
1637:
1638: G_Customer_Info.customer_id := p_cust_id;
1639:
1640: -- Getting info from HZ_CUST_ACCOUNTS
1641:
1642: BEGIN
1643: SELECT customer_class_code, sales_channel_code
1644: INTO G_Customer_Info.customer_class_code, G_Customer_Info.sales_channel_code

Line 1645: FROM hz_cust_accounts

1641:
1642: BEGIN
1643: SELECT customer_class_code, sales_channel_code
1644: INTO G_Customer_Info.customer_class_code, G_Customer_Info.sales_channel_code
1645: FROM hz_cust_accounts
1646: WHERE cust_account_id = p_cust_id;
1647:
1648: EXCEPTION
1649: WHEN no_data_found THEN

Line 1685: from hz_parties hp,hz_cust_accounts hca

1681: BEGIN
1682:
1683: SELECT NVL(gsa_indicator_flag,'N')
1684: into G_Customer_Info.gsa_indicator
1685: from hz_parties hp,hz_cust_accounts hca
1686: where hp.party_id = hca.party_id
1687: and hca.cust_account_id = p_cust_id ;
1688:
1689: EXCEPTION