[Home] [Help]
623: delete from pay_quickpay_inclusions pqi
624: where pqi.element_entry_id = p_element_entry_id
625: and exists
626: (select null
627: from pay_assignment_actions paa,
628: pay_payroll_actions ppa
629: where paa.assignment_action_id = pqi.assignment_action_id
630: and ppa.payroll_action_id = paa.payroll_action_id
631: and ppa.date_earned between p_validation_start_date
659: delete from pay_quickpay_exclusions pqe
660: where pqe.element_entry_id = p_element_entry_id
661: and exists
662: (select null
663: from pay_assignment_actions paa,
664: pay_payroll_actions ppa
665: where paa.assignment_action_id = pqe.assignment_action_id
666: and ppa.payroll_action_id = paa.payroll_action_id
667: and ppa.date_earned between p_validation_start_date
694: --
695: --
696: cursor csr_del_or_zap is
697: select pa.effective_date
698: from pay_assignment_actions aa,
699: pay_payroll_actions pa
700: where aa.assignment_id = p_assignment_id
701: and pa.action_type not in ('X', 'BEE')
702: and pa.payroll_action_id = aa.payroll_action_id
705: (pa.date_earned >= p_validation_start_date));
706: --
707: cursor csr_not_insert(l_validation_start_date date) is
708: select pa.effective_date
709: from pay_assignment_actions aa,
710: pay_payroll_actions pa
711: where aa.assignment_id = p_assignment_id
712: and pa.payroll_action_id = aa.payroll_action_id
713: and pa.action_type not in ('X', 'BEE')
831: -- into v_check_failed
832: -- from sys.dual
833: -- where exists
834: -- (select null
835: -- from pay_assignment_actions aa,
836: -- pay_payroll_actions pa
837: -- where aa.assignment_id = p_assignment_id
838: -- and pa.action_type not in ('X', 'BEE')
839: -- and pa.payroll_action_id = aa.payroll_action_id
882: -- into v_check_failed
883: -- from sys.dual
884: -- where exists
885: -- (select null
886: -- from pay_assignment_actions aa,
887: -- pay_payroll_actions pa
888: -- where aa.assignment_id = p_assignment_id
889: -- and pa.payroll_action_id = aa.payroll_action_id
890: -- and pa.action_type not in ('X', 'BEE')
1811: --
1812: -- Delete both QuickPay Inclusions AND Exclusions.
1813: --
1814: -- There is a chance the element entry id exists in both tables if
1815: -- any QuickPay assignment actions were created before the QuickPay
1816: -- Exclusions data model was in use.
1817: --
1818: hrentmnt.remove_quickpay_exclusions
1819: (p_element_entry_id,