eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on DUAL

Line 1793: -- l_offer_market_sql := 'SELECT ' || l_offer_qualifier_id || ' party_id FROM DUAL';

1789: IF l_offer_qualifier_id IS NULL THEN
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

Line 2161: -- l_offer_market_sql := 'SELECT ' || l_offer_qualifier_id || ' party_id FROM DUAL';

2157: IF l_offer_qualifier_id IS NULL THEN
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

Line 2607: FROM dual

2603: l_msg_data VARCHAR2(2048);
2604:
2605: CURSOR c_check_items(p_item_id NUMBER) IS
2606: SELECT 1
2607: FROM dual
2608: WHERE (EXISTS
2609: (SELECT 1
2610: FROM ozf_temp_eligibility
2611: WHERE object_type = 'FUND'