DBA Data[Home] [Help]

APPS.HR_PSF_BUS dependencies on PAY_ELEMENT_LINKS_F

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

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: --
5727: End If;
5728: --

Line 8159: -- - PAY_ELEMENT_LINKS_F

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

Line 8202: from pay_element_links_f

8198: cursor csr_element_links is
8199: select null
8200: from sys.dual
8201: where exists(select null
8202: from pay_element_links_f
8203: where position_id = p_position_id
8204: and (p_datetrack_mode = 'ZAP'
8205: or (p_datetrack_mode = 'DELETE'
8206: and effective_start_date >= p_validation_start_date)));