DBA Data[Home] [Help]

APPS.PQH_WKS_ERROR_CHK dependencies on PQH_DFLT_BUDGET_SETS

Line 2311: Table : pqh_dflt_budget_sets

2307: /*
2308: This procedure will set the log_context at wks budget sets level
2309:
2310: Display the DFLT_BUDGET_SET_NAME
2311: Table : pqh_dflt_budget_sets
2312:
2313: */
2314:
2315: l_proc varchar2(72) := g_package||'set_wst_log_context';

Line 2317: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;

2313: */
2314:
2315: l_proc varchar2(72) := g_package||'set_wst_log_context';
2316: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;
2317: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;
2318:
2319:
2320: CURSOR csr_wks_budget_sets_rec IS
2321: SELECT *

Line 2327: FROM pqh_dflt_budget_sets

2323: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
2324:
2325: CURSOR csr_dflt_budget_sets_rec ( p_dflt_budget_set_id IN number) IS
2326: SELECT *
2327: FROM pqh_dflt_budget_sets
2328: WHERE dflt_budget_set_id = p_dflt_budget_set_id;
2329:
2330: BEGIN
2331:

Line 2389: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;

2385: l_worksheet_bdgt_elmnts_rec pqh_worksheet_bdgt_elmnts%ROWTYPE;
2386: l_pay_element_types_rec pay_element_types%ROWTYPE;
2387:
2388: l_worksheet_budget_sets_rec pqh_worksheet_budget_sets%ROWTYPE;
2389: l_dflt_budget_sets_rec pqh_dflt_budget_sets%ROWTYPE;
2390:
2391:
2392:
2393: CURSOR csr_wks_bdgt_elmnts_rec IS

Line 2410: FROM pqh_dflt_budget_sets

2406: WHERE worksheet_budget_set_id = p_worksheet_budget_set_id;
2407:
2408: CURSOR csr_dflt_budget_sets_rec ( p_dflt_budget_set_id IN number) IS
2409: SELECT *
2410: FROM pqh_dflt_budget_sets
2411: WHERE dflt_budget_set_id = p_dflt_budget_set_id;
2412:
2413:
2414: BEGIN