[Home] [Help]
577: , p_curr_eff_date => p_run_effective_date -- run effective_date
578: , p_date_earned => p_date_earned -- payroll date_earned
579: , p_curr_pymt_eff_date => p_latest_period_payment_date -- latest payment date /* Bug No : 2470554 */
580: , p_tax_unit_id => l_tax_unit_id -- tax_unit_id needed for Choose Payslip region.
581: , p_time_period_id => p_time_period_id -- time_period_id from per_time_periods /* Bug No:2496783 */
582: , p_ppp_source_action_id => NULL
583: , p_run_action_id => p_pay_assignment_action_id
584: );
585:
810: pay_assignment_actions paa_run,
811: pay_action_interlocks pai_run,
812: pay_payroll_actions ppa_pre,
813: pay_payroll_actions ppa_run,
814: per_time_periods ptp
815: where paa_arch_mst.assignment_action_id = p_master_aa_id
816: and paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
817: and paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id
818: and paa_arch_chd.assignment_id = paa_arch_mst.assignment_id
842: IS
843: SELECT pps.actual_termination_date
844: FROM pay_payroll_actions ppa,
845: pay_assignment_actions paa,
846: per_time_periods ptp,
847: per_all_assignments_f paf,
848: per_periods_of_service pps
849: WHERE paa.assignment_action_id = p_assignment_action_id
850: AND ppa.payroll_action_id = paa.payroll_action_id
915: p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id, -- prepayment assignment_action_id
916: p_date_earned => csr_rec.run_date_earned, -- payroll date_earned
917: p_latest_period_payment_date => l_payment_date, -- latest payment date /*BugNo:5495382*/
918: p_run_effective_date => csr_rec.run_effective_date, -- run effective Date
919: p_time_period_id => csr_rec.time_period_id, -- time_period_id from per_time_periods
920: p_pre_effective_date => csr_rec.pre_effective_date
921: -- prepayment effective date, bug 5730336
922: );
923: -- Call to procedure to archive accrual and absennce details