APPS.PAY_CORE_UPGRADE_PKG dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 1637: from pay_assignment_link_usages_f alu

1633: p_asg_effective_end_date date) is
1634: select alu.assignment_link_usage_id,
1635: alu.effective_start_date,
1636: alu.effective_end_date
1637: from pay_assignment_link_usages_f alu
1638: where alu.assignment_id = p_asg_id
1639: and alu.effective_start_date <= p_asg_effective_end_date
1640: and alu.effective_end_date >= p_asg_effective_start_date;
1641: --

Line 1658: delete pay_assignment_link_usages_f alu

1654: -- Delete all assigment link usages where no part of the parent assignment
1655: -- is a non-applicant assignment (i.e. the entire assignment is for an
1656: -- applicant).
1657: --
1658: delete pay_assignment_link_usages_f alu
1659: where not exists (
1660: select null
1661: from per_all_assignments_f asg
1662: where asg.assignment_id = alu.assignment_id

Line 1745: update pay_assignment_link_usages_f

1741: --
1742: -- Do bulk update of ALU start dates
1743: --
1744: forall i in 1 .. l_alu_update_table.alu_id.count
1745: update pay_assignment_link_usages_f
1746: set effective_start_date = l_alu_update_table.effective_start_date(i)
1747: where assignment_link_usage_id = l_alu_update_table.alu_id(i);
1748: --
1749: end if;

Line 1756: delete pay_assignment_link_usages_f

1752: --
1753: -- Do bulk delete of ALUs that only belong to applicant assignments
1754: --
1755: forall i in 1 .. l_alu_delete_table.alu_id.count
1756: delete pay_assignment_link_usages_f
1757: where assignment_link_usage_id = l_alu_delete_table.alu_id(i)
1758: and effective_start_date = l_alu_delete_table.effective_start_date(i);
1759: --
1760: end if;