APPS.HRI_OLTP_DISC_WRKFRC dependencies on PER_BUDGET_ELEMENTS

Line 236: l_grade_id per_budget_elements.grade_id%type;

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;
239: l_period_end_date per_time_periods.end_date%type;
240: l_position_id per_budget_elements.position_id%type;

Line 237: l_job_id per_budget_elements.job_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;
239: l_period_end_date per_time_periods.end_date%type;
240: l_position_id per_budget_elements.position_id%type;
241:

Line 238: l_organization_id per_budget_elements.organization_id%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;
239: l_period_end_date per_time_periods.end_date%type;
240: l_position_id per_budget_elements.position_id%type;
241:
242: BEGIN

Line 240: l_position_id per_budget_elements.position_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;
239: l_period_end_date per_time_periods.end_date%type;
240: l_position_id per_budget_elements.position_id%type;
241:
242: BEGIN
243:
244: -- Return zero if any of the mandatory input parameters is null

Line 588: l_grade_id per_budget_elements.grade_id%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;
591: l_period_end_date per_time_periods.end_date%type;
592: l_position_id per_budget_elements.position_id%type;

Line 589: l_job_id per_budget_elements.job_id%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;
591: l_period_end_date per_time_periods.end_date%type;
592: l_position_id per_budget_elements.position_id%type;
593: p_formula_id ff_formulas_x.formula_id%type;

Line 590: l_organization_id per_budget_elements.organization_id%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;
591: l_period_end_date per_time_periods.end_date%type;
592: l_position_id per_budget_elements.position_id%type;
593: p_formula_id ff_formulas_x.formula_id%type;
594:

Line 592: l_position_id per_budget_elements.position_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;
591: l_period_end_date per_time_periods.end_date%type;
592: l_position_id per_budget_elements.position_id%type;
593: p_formula_id ff_formulas_x.formula_id%type;
594:
595: BEGIN
596:

Line 1057: l_grade_id per_budget_elements.grade_id%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;
1060: l_period_end_date per_time_periods.end_date%type;
1061: l_position_id per_budget_elements.position_id%type;

Line 1058: l_job_id per_budget_elements.job_id%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;
1060: l_period_end_date per_time_periods.end_date%type;
1061: l_position_id per_budget_elements.position_id%type;
1062: p_formula_id ff_formulas_x.formula_id%type;

Line 1059: l_organization_id per_budget_elements.organization_id%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;
1060: l_period_end_date per_time_periods.end_date%type;
1061: l_position_id per_budget_elements.position_id%type;
1062: p_formula_id ff_formulas_x.formula_id%type;
1063:

Line 1061: l_position_id per_budget_elements.position_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;
1060: l_period_end_date per_time_periods.end_date%type;
1061: l_position_id per_budget_elements.position_id%type;
1062: p_formula_id ff_formulas_x.formula_id%type;
1063:
1064: BEGIN
1065: