APPS.HRI_OLTP_DISC_WRKFRC dependencies on PER_ALL_ASSIGNMENTS_F

Line 232: l_assignment_id per_all_assignments_f.assignment_id%type;

228: AND ast.per_system_status = 'ACTIVE_ASSIGN';
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;

Line 582: l_assignment_id per_all_assignments_f.assignment_id%type;

578: and ast.per_system_status = 'ACTIVE_ASSIGN';
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;

Line 831: FROM per_all_assignments_f asg, per_all_people_f peo

827: -- 17-OCT-2001, bug 2052714, fixed to exclude terminated direct reports from the count
828: --
829:
830: SELECT count(*) INTO v_direct_reports
831: FROM per_all_assignments_f asg, per_all_people_f peo
832: WHERE asg.supervisor_id = v_person_id
833: AND v_effective_end_date BETWEEN asg.effective_start_date
834: AND asg.effective_end_date
835: AND asg.person_id = peo.person_id

Line 1051: l_assignment_id per_all_assignments_f.assignment_id%type;

1047: and ast.per_system_status = 'ACTIVE_ASSIGN';
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;