APPS.OZF_BUDGETAPPROVAL_PVT dependencies on HZ_CUST_ACCOUNTS

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

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

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

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

Line 2636: FROM hz_cust_accounts

2632:
2633: /* currently validation use party_id, so get party_id only */
2634: CURSOR c_get_party_id IS
2635: SELECT party_id
2636: FROM hz_cust_accounts
2637: WHERE cust_account_id = p_cust_account_id;
2638:
2639: BEGIN
2640: x_qualify_flag := false;