DBA Data[Home] [Help]

APPS.HR_PSF_BUS dependencies on PAY_ELEMENT_LINKS_F

Line 5607: -- Removed refernce to 'pay_element_links_f' since assignment and position

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: --
5610: End If;
5611: --

Line 8032: -- - PAY_ELEMENT_LINKS_F

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: --
8036: -- In Arguments:

Line 8075: from pay_element_links_f

8071: cursor csr_element_links is
8072: select null
8073: from sys.dual
8074: where exists(select null
8075: from pay_element_links_f
8076: where position_id = p_position_id
8077: and (p_datetrack_mode = 'ZAP'
8078: or (p_datetrack_mode = 'DELETE'
8079: and effective_start_date >= p_validation_start_date)));