[Home] [Help]
5247: l_no_assignments number;
5248: --
5249: cursor c_no_assignments(p_position_id number, p_effective_date date) is
5250: select count(1)
5251: from per_all_assignments_f asg, per_assignment_status_types ast
5252: where asg.position_id = p_position_id
5253: and p_effective_date between asg.effective_start_date and asg.effective_end_date
5254: and asg.assignment_type in ('E', 'C')
5255: and asg.assignment_status_type_id = ast.assignment_status_type_id
5601: End If;
5602: */
5603: --
5604: -- Bug 3199913
5605: -- Removed refernce to 'per_all_assignments_f' since assignment and position
5606: -- do not have parent-child relationship.
5607: -- Removed refernce to 'pay_element_links_f' since assignment and position
5608: -- do not have parent-child relationship.
5609: --
5647: l_count number;
5648: --
5649: cursor c1 is
5650: select count(*)
5651: from per_all_assignments_f
5652: where position_id = p_position_id
5653: and effective_start_date between p_validate_start_date and p_validate_end_date;
5654: --
5655: --
8027: --
8028: -- Description:
8029: -- Validates that a position cannot be purged if foreign key
8030: -- references exist to any of the following tables :
8031: -- - PER_ALL_ASSIGNMENTS_F
8032: -- - PAY_ELEMENT_LINKS_F
8033: -- Pre-conditions:
8034: -- None
8035: --
8061: cursor csr_assgt is
8062: select null
8063: from sys.dual
8064: where exists(select null
8065: from per_all_assignments_f
8066: where position_id = p_position_id
8067: and (p_datetrack_mode = 'ZAP'
8068: or (p_datetrack_mode = 'DELETE'
8069: and effective_start_date >= p_validation_start_date)));
8366: where psf.position_id = p_position_id;
8367: --
8368: cursor c2 is
8369: select min(effective_start_date)
8370: from per_all_assignments_f paf
8371: where paf.position_id = p_position_id;
8372: --
8373: cursor c3 is
8374: select min(effective_start_date)