APPS.HR_CHANGE_START_DATE_API dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 728: from per_assignment_budget_values_f bud,

724: ,p_type VARCHAR2) is
725: cursor csr_budget_pds is
726: select 'x' from dual where exists
727: (select 1
728: from per_assignment_budget_values_f bud,
729: per_periods_of_service p,
730: per_assignments_f a
731: where a.person_id = p_person_id
732: and a.period_of_service_id = p.period_of_service_id

Line 755: from per_assignment_budget_values_f bud,

751: --
752: cursor csr_budget_pdp is
753: select 'x' from dual where exists
754: (select 1
755: from per_assignment_budget_values_f bud,
756: per_periods_of_placement p,
757: per_assignments_f a
758: where a.person_id = p_person_id
759: and a.period_of_placement_date_start = p.date_start

Line 1477: from per_assignment_budget_values_f abv

1473: ,p_new_start_date date
1474: ,p_type VARCHAR2) is
1475: cursor csr_abv is
1476: select abv.assignment_budget_value_id
1477: from per_assignment_budget_values_f abv
1478: where assignment_id in (select a.assignment_id
1479: from per_assignments_f a
1480: where person_id = p_person_id
1481: and a.assignment_type = p_type

Line 1485: l_abv_id per_assignment_budget_values_f.assignment_budget_value_id%TYPE;

1481: and a.assignment_type = p_type
1482: and a.effective_start_date = p_old_start_date)
1483: and abv.effective_start_date = p_old_start_date;
1484: --
1485: l_abv_id per_assignment_budget_values_f.assignment_budget_value_id%TYPE;
1486: --
1487: begin
1488: open csr_abv;
1489: loop

Line 1492: update PER_ASSIGNMENT_BUDGET_VALUES_F

1488: open csr_abv;
1489: loop
1490: fetch csr_abv into l_abv_id;
1491: exit when csr_abv%NOTFOUND;
1492: update PER_ASSIGNMENT_BUDGET_VALUES_F
1493: set effective_start_date = p_new_start_date
1494: where effective_start_date = p_old_start_date
1495: and effective_end_date >= p_new_start_date
1496: and ASSIGNMENT_BUDGET_VALUE_ID = l_abv_id;