[Home] [Help]
205: WHERE paa.payroll_action_id = ppa.payroll_action_id
206: AND paa.assignment_id = p_assignment_id
207: AND last_day(ppa.date_earned) = l_virtual_date
208: AND paa.source_action_id IS NULL
209: AND ppa.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')-- Added as a part of bug fix 4774108
210: AND ppa.action_type in ('Q','R','I','B')
211: ORDER BY paa.action_sequence DESC ;
212:
213:
974: WHERE ppa.payroll_action_id = paa.payroll_action_id
975: AND ppa.action_type IN ('Q','R')
976: AND ppa.action_status = 'C'
977: AND paa.source_action_id IS NULL
978: AND ppa.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
979: AND paa.assignment_id = p_assignment_id
980: ORDER BY ppa.date_earned DESC;
981: -- The cursor to obtain start and end date of the effective date's month.
982: CURSOR c_payroll_month_dates
995: FROM per_all_assignments_f asg
996: ,hr_soft_coding_keyflex scl
997: WHERE asg.assignment_id = p_assignment_id
998: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
999: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1000: AND ( asg.effective_start_date BETWEEN p_start_date AND p_end_date
1001: OR
1002: asg.effective_end_date BETWEEN p_start_date AND p_end_date
1003: );
1007: IS
1008: SELECT organization_id
1009: FROM hr_organization_units
1010: WHERE NAME = p_org_name
1011: AND business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
1012:
1013: -- The cursor to find the most recent 'assignment start date' for the effective date
1014: CURSOR c_asg_start_date
1015: IS
1030: FROM per_all_assignments_f asg
1031: ,hr_soft_coding_keyflex scl
1032: WHERE asg.assignment_id = p_assignment_id
1033: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1034: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1035: AND scl.segment1 = p_latest_org_id
1036: AND ( asg.effective_start_date BETWEEN p_start_date AND p_end_date
1037: OR
1038: asg.effective_end_date BETWEEN p_start_date AND p_end_date