APPS.HR_CHANGE_START_DATE_API dependencies on PAY_COST_ALLOCATIONS_F

Line 637: from PAY_COST_ALLOCATIONS_F ca,

633: ,p_type VARCHAR2) is
634: cursor csr_cost_pds is
635: select 'x' from dual where exists
636: (select 1
637: from PAY_COST_ALLOCATIONS_F ca,
638: per_periods_of_service p,
639: per_assignments_f a
640: where a.person_id = p_person_id
641: and a.period_of_service_id = p.period_of_service_id

Line 664: from PAY_COST_ALLOCATIONS_F ca,

660: --
661: cursor csr_cost_pdp is
662: select 'x' from dual where exists
663: (select 1
664: from PAY_COST_ALLOCATIONS_F ca,
665: per_periods_of_placement p,
666: per_assignments_f a
667: where a.person_id = p_person_id
668: and a.period_of_placement_date_start = p.date_start

Line 1439: from PAY_COST_ALLOCATIONS_F pca

1435: ,p_new_start_date date
1436: ,p_type VARCHAR2) is
1437: cursor csr_cost is
1438: select COST_ALLOCATION_ID
1439: from PAY_COST_ALLOCATIONS_F pca
1440: where assignment_id in (select a.assignment_id
1441: from per_assignments_f a
1442: where person_id = p_person_id
1443: and a.assignment_type = p_type

Line 1447: l_ca_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;

1443: and a.assignment_type = p_type
1444: and a.effective_start_date = p_old_start_date)
1445: and pca.effective_start_date = p_old_start_date;
1446: --
1447: l_ca_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
1448: --
1449: begin
1450: open csr_cost;
1451: loop

Line 1454: update PAY_COST_ALLOCATIONS_F

1450: open csr_cost;
1451: loop
1452: fetch csr_cost into l_ca_id;
1453: exit when csr_cost%NOTFOUND;
1454: update PAY_COST_ALLOCATIONS_F
1455: set effective_start_date = p_new_start_date
1456: where effective_start_date = p_old_start_date
1457: and COST_ALLOCATION_ID = l_ca_id;
1458: if sql%rowcount <1 then

Line 1460: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');

1456: where effective_start_date = p_old_start_date
1457: and COST_ALLOCATION_ID = l_ca_id;
1458: if sql%rowcount <1 then
1459: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1460: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
1461: hr_utility.raise_error;
1462: end if;
1463: end loop;
1464: close csr_cost;