APPS.HR_CHANGE_START_DATE_API dependencies on PAY_COST_ALLOCATIONS_F

Line 565: from PAY_COST_ALLOCATIONS_F ca,

561: ,p_type VARCHAR2) is
562: cursor csr_cost_pds is
563: select 'x' from dual where exists
564: (select 1
565: from PAY_COST_ALLOCATIONS_F ca,
566: per_periods_of_service p,
567: per_assignments_f a
568: where a.person_id = p_person_id
569: and a.period_of_service_id = p.period_of_service_id

Line 579: from PAY_COST_ALLOCATIONS_F ca,

575: --
576: cursor csr_cost_pdp is
577: select 'x' from dual where exists
578: (select 1
579: from PAY_COST_ALLOCATIONS_F ca,
580: per_periods_of_placement p,
581: per_assignments_f a
582: where a.person_id = p_person_id
583: and a.period_of_placement_date_start = p.date_start

Line 1091: from PAY_COST_ALLOCATIONS_F pca

1087: ,p_new_start_date date
1088: ,p_type VARCHAR2) is
1089: cursor csr_cost is
1090: select COST_ALLOCATION_ID
1091: from PAY_COST_ALLOCATIONS_F pca
1092: where assignment_id in (select a.assignment_id
1093: from per_assignments_f a
1094: where person_id = p_person_id
1095: and a.assignment_type = p_type

Line 1099: l_ca_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;

1095: and a.assignment_type = p_type
1096: and a.effective_start_date = p_old_start_date)
1097: and pca.effective_start_date = p_old_start_date;
1098: --
1099: l_ca_id PAY_COST_ALLOCATIONS_F.COST_ALLOCATION_ID%TYPE;
1100: --
1101: begin
1102: open csr_cost;
1103: loop

Line 1106: update PAY_COST_ALLOCATIONS_F

1102: open csr_cost;
1103: loop
1104: fetch csr_cost into l_ca_id;
1105: exit when csr_cost%NOTFOUND;
1106: update PAY_COST_ALLOCATIONS_F
1107: set effective_start_date = p_new_start_date
1108: where effective_start_date = p_old_start_date
1109: and COST_ALLOCATION_ID = l_ca_id;
1110: if sql%rowcount <1 then

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

1108: where effective_start_date = p_old_start_date
1109: and COST_ALLOCATION_ID = l_ca_id;
1110: if sql%rowcount <1 then
1111: hr_utility.set_message(801,'HR_6094_ALL_CANT_UPDATE');
1112: hr_utility.set_message_token('TABLE','PAY_COST_ALLOCATIONS_F');
1113: hr_utility.raise_error;
1114: end if;
1115: end loop;
1116: close csr_cost;