[Home] [Help]
715: FROM pay_assignment_actions paa
716: ,pay_payroll_actions ppa
717: ,pay_run_results prr
718: ,pay_run_result_values prrv
719: ,per_time_periods ptp
720: ,pay_element_types_f pet
721: ,pay_input_values_f piv
722: ,pay_element_entries_f pee
723: ,per_absence_attendance_types pat
1736: ,p_curr_eff_date => p_run_effective_date -- run effective_date
1737: ,p_date_earned => p_date_earned -- payroll date_earned
1738: ,p_curr_pymt_eff_date => p_latest_period_payment_date -- latest payment date
1739: ,p_tax_unit_id => l_tax_unit_id -- tax_unit_id needed for Choose Payslip region.
1740: ,p_time_period_id => p_time_period_id -- time_period_id from per_time_periods
1741: ,p_ppp_source_action_id => NULL
1742: ,p_run_action_id => p_pay_assignment_action_id
1743: );
1744: pay_in_utils.set_location(g_debug,l_procedure, 30);
4294: ,per_business_groups pbg
4295: ,pay_action_interlocks pai_run
4296: ,pay_assignment_actions paa_run
4297: ,pay_payroll_actions ppa_run
4298: ,per_time_periods ptp
4299: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
4300: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id
4301: AND paa_arch_chd.payroll_action_id = paa_arch_mst.payroll_action_id
4302: AND ppa_pre.business_group_id = pbg.business_group_id
4392: IS
4393: SELECT pps.actual_termination_date
4394: FROM pay_payroll_actions ppa,
4395: pay_assignment_actions paa,
4396: per_time_periods ptp,
4397: per_all_assignments_f paf,
4398: per_periods_of_service pps
4399: WHERE paa.assignment_action_id = p_assignment_action_id
4400: AND ppa.payroll_action_id = paa.payroll_action_id
4654: ,p_curr_pymt_ass_act_id => csr_rec.pre_assignment_action_id -- prepayment assignment_action_id
4655: ,p_date_earned => csr_rec.run_date_earned -- payroll date_earned
4656: ,p_latest_period_payment_date => l_payment_date -- latest payment date
4657: ,p_run_effective_date => csr_rec.run_effective_date -- run effective Date
4658: ,p_time_period_id => csr_rec.time_period_id -- time_period_id from per_time_periods
4659: ,p_pre_effective_date => csr_rec.pre_effective_date -- prepayment effective date
4660: );
4661: pay_in_utils.set_location(g_debug,l_procedure, 200);
4662: