APPS.OZF_BUDGETAPPROVAL_PVT dependencies on HZ_CUST_ACCOUNTS

Line 1794: select party.party_id from hz_cust_accounts account,hz_parties party where account.party_id=party.party_id and account.cust_account_id =

1790: l_offer_market_sql := NULL;
1791: ELSE
1792: /* yzhao: 02/28/2003 fix bug 2828596(2761622) AMS: VALIDATE MARKET ELIGIBILITY AND PRODUCT ELIGIBILITY BREAKS BUDGET APPROVAL
1793: -- l_offer_market_sql := 'SELECT ' || l_offer_qualifier_id || ' party_id FROM DUAL';
1794: select party.party_id from hz_cust_accounts account,hz_parties party where account.party_id=party.party_id and account.cust_account_id =
1795: */
1796: l_offer_mark := TRUE;
1797: l_context := 'CUSTOMER'; -- same as customer sold to
1798: l_attribute := 'QUALIFIER_ATTRIBUTE2';

Line 2162: select party.party_id from hz_cust_accounts account,hz_parties party where account.party_id=party.party_id and account.cust_account_id =

2158: l_offer_market_sql := NULL;
2159: ELSE
2160: /* yzhao: 02/28/2003 fix bug 2828596(2761622) AMS: VALIDATE MARKET ELIGIBILITY AND PRODUCT ELIGIBILITY BREAKS BUDGET APPROVAL
2161: -- l_offer_market_sql := 'SELECT ' || l_offer_qualifier_id || ' party_id FROM DUAL';
2162: select party.party_id from hz_cust_accounts account,hz_parties party where account.party_id=party.party_id and account.cust_account_id =
2163: */
2164: l_offer_mark := TRUE;
2165: l_context := 'CUSTOMER'; -- same as customer sold to
2166: l_attribute := 'QUALIFIER_ATTRIBUTE2';

Line 2632: FROM hz_cust_accounts

2628:
2629: /* currently validation use party_id, so get party_id only */
2630: CURSOR c_get_party_id IS
2631: SELECT party_id
2632: FROM hz_cust_accounts
2633: WHERE cust_account_id = p_cust_account_id;
2634:
2635: BEGIN
2636: x_qualify_flag := false;