APPS.PER_SALADMIN_UTILITY dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 758: from per_assignment_budget_values_f abv, per_all_assignments_f asg,

754: RETURN NUMBER IS
755: l_fte number;
756: cursor c1(p_assignment_id number, p_effective_date date) is
757: select abv.value
758: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
759: per_assignment_status_types ast
760: where asg.assignment_id = p_assignment_id
761: and abv.assignment_id = asg.assignment_id
762: and asg.assignment_type in ('E', 'C')

Line 1368: from per_assignment_budget_values_f

1364:
1365: CURSOR csr_fte_BFTE
1366: IS
1367: select nvl(value, 1) val
1368: from per_assignment_budget_values_f
1369: where assignment_id = p_assignment_id
1370: and unit = 'FTE'
1371: and p_effective_date BETWEEN effective_start_date AND effective_end_date;
1372: CURSOR csr_fte_BPFT

Line 1375: from per_assignment_budget_values_f

1371: and p_effective_date BETWEEN effective_start_date AND effective_end_date;
1372: CURSOR csr_fte_BPFT
1373: IS
1374: select nvl(value, 1) val
1375: from per_assignment_budget_values_f
1376: where assignment_id = p_assignment_id
1377: and unit = 'PFT'
1378: and p_effective_date BETWEEN effective_start_date AND effective_end_date;
1379:

Line 1465: from per_assignment_budget_values_f abv, per_all_assignments_f asg,

1461: function get_assignment_fte(p_assignment_id number, p_effective_date date) return number is
1462: l_fte number := 0;
1463: cursor c1(p_assignment_id number, p_effective_date date) is
1464: select nvl(abv.value,0)
1465: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
1466: per_assignment_status_types ast
1467: where asg.assignment_id = p_assignment_id
1468: and abv.assignment_id = asg.assignment_id
1469: and asg.assignment_type in ('E', 'C')