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 1797: -- l_offer_market_sql := 'SELECT ' || l_offer_qualifier_id || ' party_id FROM DUAL';

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

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

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

Line 2611: FROM dual

2607: l_msg_data VARCHAR2(2048);
2608:
2609: CURSOR c_check_items(p_item_id NUMBER) IS
2610: SELECT 1
2611: FROM dual
2612: WHERE (EXISTS
2613: (SELECT 1
2614: FROM ozf_temp_eligibility
2615: WHERE object_type = 'FUND'