APPS.PER_SPP_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 25: -- - Validates that a assignment_id exists in table per_all_assignments_f.

21: -- |-------------------------< chk_assignment_id >--------------------------|
22: -- ---------------------------------------------------------------------------
23: --
24: -- Description:
25: -- - Validates that a assignment_id exists in table per_all_assignments_f.
26: -- - Checks that the assignment_id is not null
27: -- - Check if a placement has already been created for the assignment_id.
28: --
29: -- Pre-conditions:

Line 37: -- If a row does exist in per_all_assignments for the given assignment id then

33: -- p_assignment_id
34: --
35: --
36: -- Post Success:
37: -- If a row does exist in per_all_assignments for the given assignment id then
38: -- processing continues.
39: --
40: -- Post Failure:
41: -- If a row does not exist in per_all_assignments_f for the given assignment id

Line 41: -- If a row does not exist in per_all_assignments_f for the given assignment id

37: -- If a row does exist in per_all_assignments for the given assignment id then
38: -- processing continues.
39: --
40: -- Post Failure:
41: -- If a row does not exist in per_all_assignments_f for the given assignment id
42: -- then an application error will be raised and processing is terminated.
43: --
44: -- Access Status:
45: -- Internal Table Handler Use Only.

Line 68: from per_all_assignments_f paa

64: l_placement_id number;
65: --
66: cursor csr_valid_assignment_id is
67: select assignment_id paa
68: from per_all_assignments_f paa
69: where paa.assignment_id = p_assignment_id
70: and p_effective_date between
71: effective_start_date and effective_end_date;
72:

Line 190: from per_all_assignments_f

186: --
187: Cursor csr_special_ceiling is
188: select special_ceiling_step_id,
189: grade_id
190: from per_all_assignments_f
191: where assignment_id = p_assignment_id
192: and p_effective_date between effective_start_date
193: and effective_end_date;
194: --

Line 912: from per_all_assignments_f paf, per_spinal_point_placements_f psf

908: --Cursor to select current assignemnt grade.
909: --
910: cursor c_curr_grade is
911: select paf.grade_id , paf.assignment_id
912: from per_all_assignments_f paf, per_spinal_point_placements_f psf
913: where paf.assignment_id = psf.assignment_id
914: and psf.placement_id = p_placement_id
915: and p_effective_date between psf.effective_start_Date and psf.effective_end_date
916: and p_effective_date between paf.effective_start_Date and paf.effective_end_date;

Line 933: from per_all_assignments_f paf

929: -- cursor to check for change in grade in future assignemnt rec.
930: --
931: cursor c_future_grade_chg (p_grade_id number, p_end_date date) is
932: select 'X'
933: from per_all_assignments_f paf
934: where paf.assignment_id = l_asg_id
935: and paf.grade_id <> p_grade_id
936: and paf.effective_end_date between p_effective_date and p_end_date;
937:

Line 1288: (p_base_table_name => 'per_all_assignments_f'

1284: End If;
1285: */
1286: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
1287: NOT (dt_api.check_min_max_dates
1288: (p_base_table_name => 'per_all_assignments_f'
1289: ,p_base_key_column => 'ASSIGNMENT_ID'
1290: ,p_base_key_value => p_assignment_id
1291: ,p_from_date => p_validation_start_date
1292: ,p_to_date => p_validation_end_date))) Then