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.

[Home] [Help]

APPS.PSB_BUDGET_GROUPS_PVT dependencies on DUAL

Line 211: from dual

207:
208: cursor c_Overlap_ps (ps_AccSet NUMBER,
209: nps_AccSet NUMBER) is
210: select 'Personnel Services and Non-Personnel Services Account Sets Overlap'
211: from dual
212: where exists
213: (select 1
214: from psb_budget_accounts a,
215: psb_budget_accounts b

Line 2196: FROM dual

2192: l_api_version CONSTANT NUMBER := 1.0;
2193:
2194: CURSOR c_p1 IS
2195: SELECT 'PSB_POSITION_ACCOUNTS'
2196: FROM dual
2197: WHERE exists
2198: (SELECT 1
2199: FROM PSB_POSITION_ACCOUNTS
2200: WHERE budget_group_id = l_budget_group_id

Line 2206: FROM dual

2202: l_p1_exists VARCHAR2(1) := FND_API.G_FALSE;
2203:
2204: CURSOR c_p2 IS
2205: SELECT 'PSB_ACCOUNT_POSITION_SETS'
2206: FROM dual
2207: WHERE exists
2208: (SELECT 1
2209: FROM PSB_ACCOUNT_POSITION_SETS
2210: WHERE budget_group_id = l_budget_group_id

Line 2215: FROM dual

2211: );
2212: l_p2_exists VARCHAR2(1) := FND_API.G_FALSE;
2213: CURSOR c_p3 IS
2214: SELECT 'PSB_BUDGET_REVISIONS'
2215: FROM dual
2216: WHERE exists
2217: (SELECT 1
2218: FROM PSB_BUDGET_REVISIONS
2219: WHERE budget_group_id = l_budget_group_id

Line 2224: FROM dual

2220: );
2221: l_p3_exists VARCHAR2(1) := FND_API.G_FALSE;
2222: CURSOR c_p4 IS
2223: SELECT 'PSB_BUDGET_REVISION_POSITIONS'
2224: FROM dual
2225: WHERE exists
2226: (SELECT 1
2227: FROM PSB_BUDGET_REVISION_POSITIONS
2228: WHERE budget_group_id = l_budget_group_id

Line 2233: FROM dual

2229: );
2230: l_p4_exists VARCHAR2(1) := FND_API.G_FALSE;
2231: CURSOR c_p5 IS
2232: SELECT 'PSB_BUDGET_REVISION_ACCOUNTS'
2233: FROM dual
2234: WHERE exists
2235: (SELECT 1
2236: FROM PSB_BUDGET_REVISION_ACCOUNTS
2237: WHERE budget_group_id = l_budget_group_id

Line 2242: FROM dual

2238: );
2239: l_p5_exists VARCHAR2(1) := FND_API.G_FALSE;
2240: CURSOR c_p6 IS
2241: SELECT 'PSB_BUDGET_WORKFLOW_RULES'
2242: FROM dual
2243: WHERE exists
2244: (SELECT 1
2245: FROM PSB_BUDGET_WORKFLOW_RULES
2246: WHERE budget_group_id = l_budget_group_id

Line 2251: FROM dual

2247: );
2248: l_p6_exists VARCHAR2(1) := FND_API.G_FALSE;
2249: CURSOR c_p7 IS
2250: SELECT 'PSB_DATA_EXTRACTS'
2251: FROM dual
2252: WHERE exists
2253: (SELECT 1
2254: FROM PSB_DATA_EXTRACTS
2255: WHERE budget_group_id = l_budget_group_id

Line 2261: FROM dual

2257: l_p7_exists VARCHAR2(1) := FND_API.G_FALSE;
2258:
2259: CURSOR c_p8 IS
2260: SELECT 'PSB_WS_POSITION_LINES'
2261: FROM dual
2262: WHERE exists
2263: (SELECT 1
2264: FROM PSB_WS_POSITION_LINES
2265: WHERE budget_group_id = l_budget_group_id

Line 2270: FROM dual

2266: );
2267: l_p8_exists VARCHAR2(1) := FND_API.G_FALSE;
2268: CURSOR c_p9 IS
2269: SELECT 'PSB_POSITIONS'
2270: FROM dual
2271: WHERE exists
2272: (SELECT 1
2273: FROM PSB_POSITIONS
2274: WHERE budget_group_id = l_budget_group_id

Line 2280: FROM dual

2276: l_p9_exists VARCHAR2(1) := FND_API.G_FALSE;
2277:
2278: CURSOR c_p10 IS
2279: SELECT 'PSB_ENTITY_SET'
2280: FROM dual
2281: WHERE exists
2282: (SELECT 1
2283: FROM PSB_ENTITY_SET
2284: WHERE budget_group_id = l_budget_group_id

Line 2290: FROM dual

2286: l_p10_exists VARCHAR2(1) := FND_API.G_FALSE;
2287:
2288: CURSOR c_p11 IS
2289: SELECT 'PSB_ENTITY'
2290: FROM dual
2291: WHERE exists
2292: (SELECT 1
2293: FROM PSB_ENTITY
2294: WHERE budget_group_id = l_budget_group_id

Line 2300: FROM dual

2296: l_p11_exists VARCHAR2(1) := FND_API.G_FALSE;
2297:
2298: CURSOR c_p12 IS
2299: SELECT 'PSB_WS_DISTRIBUTION_RULE_LINES'
2300: FROM dual
2301: WHERE exists
2302: (SELECT 1
2303: FROM PSB_WS_DISTRIBUTION_RULE_LINES
2304: WHERE budget_group_id = l_budget_group_id

Line 2310: FROM dual

2306: l_p12_exists VARCHAR2(1) := FND_API.G_FALSE;
2307:
2308: CURSOR c_p13 IS
2309: SELECT 'PSB_WS_DISTRIBUTION_RULES'
2310: FROM dual
2311: WHERE exists
2312: (SELECT 1
2313: FROM PSB_WS_DISTRIBUTION_RULES
2314: WHERE budget_group_id = l_budget_group_id

Line 2320: FROM dual

2316: l_p13_exists VARCHAR2(1) := FND_API.G_FALSE;
2317:
2318: CURSOR c_p14 IS
2319: SELECT 'PSB_WS_LINE_BALANCES_I'
2320: FROM dual
2321: WHERE exists
2322: (SELECT 1
2323: FROM PSB_WS_LINE_BALANCES_I
2324: WHERE budget_group_id = l_budget_group_id

Line 2330: FROM dual

2326: l_p14_exists VARCHAR2(1) := FND_API.G_FALSE;
2327:
2328: CURSOR c_p15 IS
2329: SELECT 'PSB_WORKSHEETS'
2330: FROM dual
2331: WHERE exists
2332: (SELECT 1
2333: FROM PSB_WORKSHEETS
2334: WHERE budget_group_id = l_budget_group_id

Line 2340: FROM dual

2336: l_p15_exists VARCHAR2(1) := FND_API.G_FALSE;
2337:
2338: CURSOR c_p16 IS
2339: SELECT 'PSB_WS_ACCOUNT_LINES'
2340: FROM dual
2341: WHERE exists
2342: (SELECT 1
2343: FROM PSB_WS_ACCOUNT_LINES
2344: WHERE budget_group_id = l_budget_group_id

Line 2965: Into l_budget_group_resp_id from DUAL ;

2961: if BG_resp_Cur%NOTFOUND then
2962: EXIT;
2963: else
2964: select PSB_BUDGET_GROUP_RESP_S.NEXTVAL
2965: Into l_budget_group_resp_id from DUAL ;
2966:
2967: Insert into psb_budget_group_resp
2968: (budget_group_resp_id,
2969: budget_group_id,

Line 3004: Into l_budget_group_resp_id from DUAL ;

3000: if BG_Role_Cur%NOTFOUND then
3001: EXIT;
3002: else
3003: select PSB_BUDGET_GROUP_RESP_S.NEXTVAL
3004: Into l_budget_group_resp_id from DUAL ;
3005:
3006: Insert into psb_budget_group_resp
3007: (budget_group_resp_id,
3008: budget_group_id,

Line 3048: Into l_budget_group_category_id from DUAL ;

3044: if BG_WF_Cur%NOTFOUND then
3045: EXIT;
3046: else
3047: select psb_budget_group_categories_s.NEXTVAL
3048: Into l_budget_group_category_id from DUAL ;
3049:
3050: Insert into psb_budget_group_categories
3051: ( budget_group_category_id ,
3052: budget_group_id ,