[Home] [Help]
783: delete from pay_quickpay_inclusions pqi
784: where pqi.element_entry_id = p_element_entry_id
785: and exists
786: (select null
787: from pay_assignment_actions paa,
788: pay_payroll_actions ppa
789: where paa.assignment_action_id = pqi.assignment_action_id
790: and ppa.payroll_action_id = paa.payroll_action_id
791: and ppa.date_earned between p_validation_start_date
819: delete from pay_quickpay_exclusions pqe
820: where pqe.element_entry_id = p_element_entry_id
821: and exists
822: (select null
823: from pay_assignment_actions paa,
824: pay_payroll_actions ppa
825: where paa.assignment_action_id = pqe.assignment_action_id
826: and ppa.payroll_action_id = paa.payroll_action_id
827: and ppa.date_earned between p_validation_start_date
854: --
855: --
856: cursor csr_del_or_zap is
857: select pa.effective_date
858: from pay_assignment_actions aa,
859: pay_payroll_actions pa
860: where aa.assignment_id = p_assignment_id
861: and pa.action_type not in ('X', 'BEE')
862: and pa.payroll_action_id = aa.payroll_action_id
865: (pa.date_earned >= p_validation_start_date));
866: --
867: cursor csr_not_insert is
868: select pa.effective_date
869: from pay_assignment_actions aa,
870: pay_payroll_actions pa
871: where aa.assignment_id = p_assignment_id
872: and pa.payroll_action_id = aa.payroll_action_id
873: and pa.action_type not in ('X', 'BEE')
983: -- into v_check_failed
984: -- from sys.dual
985: -- where exists
986: -- (select null
987: -- from pay_assignment_actions aa,
988: -- pay_payroll_actions pa
989: -- where aa.assignment_id = p_assignment_id
990: -- and pa.action_type not in ('X', 'BEE')
991: -- and pa.payroll_action_id = aa.payroll_action_id
1022: -- into v_check_failed
1023: -- from sys.dual
1024: -- where exists
1025: -- (select null
1026: -- from pay_assignment_actions aa,
1027: -- pay_payroll_actions pa
1028: -- where aa.assignment_id = p_assignment_id
1029: -- and pa.payroll_action_id = aa.payroll_action_id
1030: -- and pa.action_type not in ('X', 'BEE')
1593: --
1594: -- Delete both QuickPay Inclusions AND Exclusions.
1595: --
1596: -- There is a chance the element entry id exists in both tables if
1597: -- any QuickPay assignment actions were created before the QuickPay
1598: -- Exclusions data model was in use.
1599: --
1600: hrentmnt.remove_quickpay_exclusions
1601: (p_element_entry_id,