[Home] [Help]
571: , p_curr_eff_date => p_run_effective_date -- run effective_date
572: , p_date_earned => p_date_earned -- payroll date_earned
573: , p_curr_pymt_eff_date => p_latest_period_payment_date -- latest payment date /* Bug No : 2470554 */
574: , p_tax_unit_id => l_tax_unit_id -- tax_unit_id needed for Choose Payslip region.
575: , p_time_period_id => p_time_period_id -- time_period_id from per_time_periods /* Bug No:2496783 */
576: , p_ppp_source_action_id => NULL
577: , p_run_action_id => p_pay_assignment_action_id
578: );
579:
804: pay_assignment_actions paa_run,
805: pay_action_interlocks pai_run,
806: pay_payroll_actions ppa_pre,
807: pay_payroll_actions ppa_run,
808: per_time_periods ptp
809: where paa_arch_mst.assignment_action_id = p_master_aa_id
810: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
811: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id
812: and paa_arch_chd.assignment_id = paa_arch_mst.assignment_id
836: IS
837: SELECT pps.actual_termination_date
838: FROM pay_payroll_actions ppa,
839: pay_assignment_actions paa,
840: per_time_periods ptp,
841: per_all_assignments_f paf,
842: per_periods_of_service pps
843: WHERE paa.assignment_action_id = p_assignment_action_id
844: AND ppa.payroll_action_id = paa.payroll_action_id
909: p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id, -- prepayment assignment_action_id
910: p_date_earned => csr_rec.run_date_earned, -- payroll date_earned
911: p_latest_period_payment_date => l_payment_date, -- latest payment date /*BugNo:5495382*/
912: p_run_effective_date => csr_rec.run_effective_date, -- run effective Date
913: p_time_period_id => csr_rec.time_period_id, -- time_period_id from per_time_periods
914: p_pre_effective_date => csr_rec.pre_effective_date
915: -- prepayment effective date, bug 5730336
916: );
917: -- Call to procedure to archive accrual and absennce details