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.HRI_OLTP_DISC_WRKFRC dependencies on PER_BUDGETS

Line 122: FROM per_budgets b

118: CURSOR budget_csr IS
119: SELECT
120: b.unit
121: ,b.business_group_id
122: FROM per_budgets b
123: WHERE b.budget_id = p_budget_id;
124:
125: CURSOR time_period_csr IS
126: SELECT tp.end_date

Line 233: l_budget_type_code per_budgets.unit%type;

229:
230: l_actuals NUMBER := 0;
231: l_actuals_total NUMBER := 0;
232: l_assignment_id per_all_assignments_f.assignment_id%type;
233: l_budget_type_code per_budgets.unit%type;
234: l_business_group_id per_budgets.business_group_id%type;
235: l_formula_id ff_formulas_f.formula_id%type;
236: l_grade_id per_budget_elements.grade_id%type;
237: l_job_id per_budget_elements.job_id%type;

Line 234: l_business_group_id per_budgets.business_group_id%type;

230: l_actuals NUMBER := 0;
231: l_actuals_total NUMBER := 0;
232: l_assignment_id per_all_assignments_f.assignment_id%type;
233: l_budget_type_code per_budgets.unit%type;
234: l_business_group_id per_budgets.business_group_id%type;
235: l_formula_id ff_formulas_f.formula_id%type;
236: l_grade_id per_budget_elements.grade_id%type;
237: l_job_id per_budget_elements.job_id%type;
238: l_organization_id per_budget_elements.organization_id%type;

Line 583: l_budget_type_code1 per_budgets.unit%type;

579:
580: l_actuals number := 0;
581: l_actuals_total number := 0;
582: l_assignment_id per_all_assignments_f.assignment_id%type;
583: l_budget_type_code1 per_budgets.unit%type;
584: l_budget_type_code2 per_budgets.unit%type;
585: l_budget_type_code3 per_budgets.unit%type;
586: l_business_group_id per_budgets.business_group_id%type;
587: l_formula_id ff_formulas_f.formula_id%type;

Line 584: l_budget_type_code2 per_budgets.unit%type;

580: l_actuals number := 0;
581: l_actuals_total number := 0;
582: l_assignment_id per_all_assignments_f.assignment_id%type;
583: l_budget_type_code1 per_budgets.unit%type;
584: l_budget_type_code2 per_budgets.unit%type;
585: l_budget_type_code3 per_budgets.unit%type;
586: l_business_group_id per_budgets.business_group_id%type;
587: l_formula_id ff_formulas_f.formula_id%type;
588: l_grade_id per_budget_elements.grade_id%type;

Line 585: l_budget_type_code3 per_budgets.unit%type;

581: l_actuals_total number := 0;
582: l_assignment_id per_all_assignments_f.assignment_id%type;
583: l_budget_type_code1 per_budgets.unit%type;
584: l_budget_type_code2 per_budgets.unit%type;
585: l_budget_type_code3 per_budgets.unit%type;
586: l_business_group_id per_budgets.business_group_id%type;
587: l_formula_id ff_formulas_f.formula_id%type;
588: l_grade_id per_budget_elements.grade_id%type;
589: l_job_id per_budget_elements.job_id%type;

Line 586: l_business_group_id per_budgets.business_group_id%type;

582: l_assignment_id per_all_assignments_f.assignment_id%type;
583: l_budget_type_code1 per_budgets.unit%type;
584: l_budget_type_code2 per_budgets.unit%type;
585: l_budget_type_code3 per_budgets.unit%type;
586: l_business_group_id per_budgets.business_group_id%type;
587: l_formula_id ff_formulas_f.formula_id%type;
588: l_grade_id per_budget_elements.grade_id%type;
589: l_job_id per_budget_elements.job_id%type;
590: l_organization_id per_budget_elements.organization_id%type;

Line 1052: l_budget_type_code1 per_budgets.unit%type;

1048:
1049: l_actuals number := 0;
1050: l_actuals_total number := 0;
1051: l_assignment_id per_all_assignments_f.assignment_id%type;
1052: l_budget_type_code1 per_budgets.unit%type;
1053: l_budget_type_code2 per_budgets.unit%type;
1054: l_budget_type_code3 per_budgets.unit%type;
1055: l_business_group_id per_budgets.business_group_id%type;
1056: l_formula_id ff_formulas_f.formula_id%type;

Line 1053: l_budget_type_code2 per_budgets.unit%type;

1049: l_actuals number := 0;
1050: l_actuals_total number := 0;
1051: l_assignment_id per_all_assignments_f.assignment_id%type;
1052: l_budget_type_code1 per_budgets.unit%type;
1053: l_budget_type_code2 per_budgets.unit%type;
1054: l_budget_type_code3 per_budgets.unit%type;
1055: l_business_group_id per_budgets.business_group_id%type;
1056: l_formula_id ff_formulas_f.formula_id%type;
1057: l_grade_id per_budget_elements.grade_id%type;

Line 1054: l_budget_type_code3 per_budgets.unit%type;

1050: l_actuals_total number := 0;
1051: l_assignment_id per_all_assignments_f.assignment_id%type;
1052: l_budget_type_code1 per_budgets.unit%type;
1053: l_budget_type_code2 per_budgets.unit%type;
1054: l_budget_type_code3 per_budgets.unit%type;
1055: l_business_group_id per_budgets.business_group_id%type;
1056: l_formula_id ff_formulas_f.formula_id%type;
1057: l_grade_id per_budget_elements.grade_id%type;
1058: l_job_id per_budget_elements.job_id%type;

Line 1055: l_business_group_id per_budgets.business_group_id%type;

1051: l_assignment_id per_all_assignments_f.assignment_id%type;
1052: l_budget_type_code1 per_budgets.unit%type;
1053: l_budget_type_code2 per_budgets.unit%type;
1054: l_budget_type_code3 per_budgets.unit%type;
1055: l_business_group_id per_budgets.business_group_id%type;
1056: l_formula_id ff_formulas_f.formula_id%type;
1057: l_grade_id per_budget_elements.grade_id%type;
1058: l_job_id per_budget_elements.job_id%type;
1059: l_organization_id per_budget_elements.organization_id%type;