[Home] [Help]
497: select paa.assignment_action_id,pay_in_tax_utils.get_period_number(ppa.payroll_id,ppa.date_earned),ppa.date_earned
498: bulk collect into l_assact_tbl,l_month_number_tbl,l_eff_date_tbl
499: from pay_payroll_Actions ppa,
500: pay_assignment_Actions paa,
501: per_assignments_f asg -- Added to remove NMV as per bug 4774108
502: where ppa.payroll_Action_id = paa.payroll_Action_id
503: and paa.assignment_id = p_assignment_id
504: and paa.assignment_id = asg.assignment_id-- Added to remove NMV as per bug 4774108
505: and asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
895: WHERE assignment_action_id = p_assact_id ;
896:
897: SELECT nvl(pps.actual_termination_date,paa.effective_end_Date),payroll_id
898: INTO l_asg_end_date,l_payroll_id
899: FROM per_Assignments_f paa,-- Modified this for 4774108 to remove NMV
900: per_periods_of_Service pps
901: WHERE paa.assignment_id = l_assignment_id
902: AND paa.period_of_service_id =pps.period_of_service_id
903: AND paa.effective_end_date = ( SELECT MAX (b.effective_end_date)
1684: CURSOR csr_asg_details
1685: IS
1686: SELECT asg.business_group_id
1687: ,asg.payroll_id
1688: FROM per_assignments_f asg
1689: WHERE asg.assignment_id = p_assignment_id
1690: AND asg.primary_flag = 'Y'
1691: AND p_effective_date BETWEEN asg.effective_start_date
1692: AND asg.effective_end_date ;
2715: IS
2716: SELECT hsc.segment2
2717: ,hsc.segment3
2718: ,hsc.segment4
2719: FROM per_assignments_f paf
2720: ,hr_soft_coding_keyflex hsc
2721: WHERE paf.assignment_id = p_assignment_id
2722: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
2723: AND paf.business_group_id = p_business_group_id
3330: AND paa.source_action_id IS NULL;
3331:
3332: CURSOR csr_cyclic_gre(p_start_date DATE,p_pre_le_end_date DATE) IS
3333: SELECT 1
3334: FROM per_assignments_f paf,
3335: hr_soft_coding_keyflex scl
3336: WHERE paf.assignment_id = p_assignment_id
3337: AND scl.segment1 = TO_CHAR(p_tax_unit_id)
3338: AND paf.SOFT_CODING_KEYFLEX_ID=scl.SOFT_CODING_KEYFLEX_ID