APPS.PQH_BUDGET dependencies on PQH_BUDGETS

Line 2470: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;

2466: p_business_group_id in number,
2467: p_rows_inserted out nocopy number) as
2468: l_budget_start_date date;
2469: l_budget_end_date date;
2470: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
2471: l_budget_entity_cd pqh_budgets.budgeted_entity_cd%type;
2472:
2473: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
2474: from pqh_budgets bge, pqh_worksheets wks

Line 2471: l_budget_entity_cd pqh_budgets.budgeted_entity_cd%type;

2467: p_rows_inserted out nocopy number) as
2468: l_budget_start_date date;
2469: l_budget_end_date date;
2470: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
2471: l_budget_entity_cd pqh_budgets.budgeted_entity_cd%type;
2472:
2473: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
2474: from pqh_budgets bge, pqh_worksheets wks
2475: where wks.budget_id = bge.budget_id

Line 2474: from pqh_budgets bge, pqh_worksheets wks

2470: l_valid_grade_flag pqh_budgets.valid_grade_reqd_flag%type;
2471: l_budget_entity_cd pqh_budgets.budgeted_entity_cd%type;
2472:
2473: cursor c0 is select budget_start_date,budget_end_date,valid_grade_reqd_flag,budgeted_entity_cd
2474: from pqh_budgets bge, pqh_worksheets wks
2475: where wks.budget_id = bge.budget_id
2476: and wks.worksheet_id = p_worksheet_id;
2477: cursor c1 is select grade_id from per_grades a
2478: where business_group_id = p_business_group_id

Line 2527: from pqh_budgets bgt, pqh_worksheets wks

2523: p_rows_inserted out nocopy number) as
2524: l_budget_start_date date;
2525: l_budget_end_date date;
2526: cursor c0 is select budget_start_date,budget_end_date
2527: from pqh_budgets bgt, pqh_worksheets wks
2528: where wks.budget_id = bgt.budget_id
2529: and wks.worksheet_id = p_worksheet_id;
2530: cursor c1 is select job_id from per_jobs
2531: where business_group_id = p_business_group_id

Line 2579: from pqh_budgets bgt, pqh_worksheets wks

2575: p_rows_inserted out nocopy number) as
2576: l_budget_start_date date;
2577: l_budget_end_date date;
2578: cursor c0 is select budget_start_date,budget_end_date
2579: from pqh_budgets bgt, pqh_worksheets wks
2580: where wks.budget_id = bgt.budget_id
2581: and wks.worksheet_id = p_worksheet_id;
2582: cursor c1 is select position_id,job_id,organization_id,availability_status_id
2583: from hr_positions

Line 2680: from pqh_budgets bgt, pqh_worksheets wks

2676: p_rows_inserted out nocopy number) as
2677: l_budget_start_date date;
2678: l_budget_end_date date;
2679: cursor c0 is select budget_start_date,budget_end_date
2680: from pqh_budgets bgt, pqh_worksheets wks
2681: where wks.budget_id = bgt.budget_id
2682: and wks.worksheet_id = p_worksheet_id;
2683: cursor c1 is select organization_id
2684: from hr_organization_units

Line 2766: from pqh_budgets bgt, pqh_worksheets wks

2762: p_rows_inserted out nocopy number) as
2763: l_budget_start_date date;
2764: l_budget_end_date date;
2765: cursor c0 is select budget_start_date,budget_end_date
2766: from pqh_budgets bgt, pqh_worksheets wks
2767: where wks.budget_id = bgt.budget_id
2768: and wks.worksheet_id = p_worksheet_id;
2769: cursor c1 is select hier.organization_id_child
2770: from per_org_structure_elements hier, hr_organization_units org

Line 3851: from pqh_budgets

3847: end post_changes;
3848:
3849: procedure init_prd_tab(p_budget_id in number) as
3850: cursor c1 is select period_set_name,budget_start_date,budget_end_date
3851: from pqh_budgets
3852: where budget_id = p_budget_id;
3853: l_period_set_name pqh_budgets.period_set_name%type;
3854: l_prd_start_date date;
3855: l_prd_end_date date;

Line 3853: l_period_set_name pqh_budgets.period_set_name%type;

3849: procedure init_prd_tab(p_budget_id in number) as
3850: cursor c1 is select period_set_name,budget_start_date,budget_end_date
3851: from pqh_budgets
3852: where budget_id = p_budget_id;
3853: l_period_set_name pqh_budgets.period_set_name%type;
3854: l_prd_start_date date;
3855: l_prd_end_date date;
3856: k number := 1;
3857: cursor c2 is select start_date

Line 5013: FROM pqh_budgets bgt

5009: );
5010: --
5011: CURSOR csr_bgt IS
5012: SELECT currency_code,business_group_id
5013: FROM pqh_budgets bgt
5014: WHERE bgt.budget_id = p_budget_id;
5015: begin
5016: open csr_bgt;
5017: fetch csr_bgt into l_currency_code,l_business_group_id;