APPS.HR_PSF_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 5253: from per_all_assignments_f asg, per_assignment_status_types ast

5249: --
5250: -- Start changes for bug 13519283
5251: cursor c_no_assignments(p_position_id number, p_effective_date date) is
5252: select asg.assignment_id, asg.effective_start_date, asg.effective_end_date
5253: from per_all_assignments_f asg, per_assignment_status_types ast
5254: where asg.position_id = p_position_id
5255: and (asg.effective_start_date >= p_effective_date
5256: or p_effective_date between asg.effective_start_date and asg.effective_end_date) -- Added for Bug#14022433
5257: and asg.assignment_type in ('E', 'C')

Line 5267: per_all_assignments_f asg,

5263: select
5264: asg.effective_start_date,
5265: asg.effective_end_date
5266: from
5267: per_all_assignments_f asg,
5268: per_assignment_status_types ast
5269: where asg.assignment_id <> lp_asg_id
5270: and asg.position_id = p_position_id
5271: and (lp_asg_start_date between asg.effective_start_date and asg.effective_end_date

Line 5722: -- Removed refernce to 'per_all_assignments_f' since assignment and position

5718: End If;
5719: */
5720: --
5721: -- Bug 3199913
5722: -- Removed refernce to 'per_all_assignments_f' since assignment and position
5723: -- do not have parent-child relationship.
5724: -- Removed refernce to 'pay_element_links_f' since assignment and position
5725: -- do not have parent-child relationship.
5726: --

Line 5768: from per_all_assignments_f

5764: l_count number;
5765: --
5766: cursor c1 is
5767: select count(*)
5768: from per_all_assignments_f
5769: where position_id = p_position_id
5770: and effective_start_date between p_validate_start_date and p_validate_end_date;
5771: --
5772: --

Line 8158: -- - PER_ALL_ASSIGNMENTS_F

8154: --
8155: -- Description:
8156: -- Validates that a position cannot be purged if foreign key
8157: -- references exist to any of the following tables :
8158: -- - PER_ALL_ASSIGNMENTS_F
8159: -- - PAY_ELEMENT_LINKS_F
8160: -- Pre-conditions:
8161: -- None
8162: --

Line 8192: from per_all_assignments_f

8188: cursor csr_assgt is
8189: select null
8190: from sys.dual
8191: where exists(select null
8192: from per_all_assignments_f
8193: where position_id = p_position_id
8194: and (p_datetrack_mode = 'ZAP'
8195: or (p_datetrack_mode = 'DELETE'
8196: and effective_start_date >= p_validation_start_date)));

Line 8497: from per_all_assignments_f paf

8493: where psf.position_id = p_position_id;
8494: --
8495: cursor c2 is
8496: select min(effective_start_date)
8497: from per_all_assignments_f paf
8498: where paf.position_id = p_position_id;
8499: --
8500: cursor c3 is
8501: select min(effective_start_date)