[Home] [Help]
207: WHERE paa.payroll_action_id = ppa.payroll_action_id
208: AND paa.assignment_id = p_assignment_id
209: AND last_day(ppa.date_earned) = l_virtual_date
210: AND paa.source_action_id IS NULL
211: AND ppa.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')-- Added as a part of bug fix 4774108
212: AND ppa.action_type in ('Q','R','I','B')
213: ORDER BY paa.action_sequence DESC ;
214:
215:
980: WHERE ppa.payroll_action_id = paa.payroll_action_id
981: AND ppa.action_type IN ('Q','R')
982: AND ppa.action_status = 'C'
983: AND paa.source_action_id IS NULL
984: AND ppa.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
985: AND paa.assignment_id = p_assignment_id
986: ORDER BY ppa.date_earned DESC;
987: -- The cursor to obtain start and end date of the effective date's month.
988: CURSOR c_payroll_month_dates
1001: FROM per_all_assignments_f asg
1002: ,hr_soft_coding_keyflex scl
1003: WHERE asg.assignment_id = p_assignment_id
1004: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1005: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1006: AND ( asg.effective_start_date BETWEEN p_start_date AND p_end_date
1007: OR
1008: asg.effective_end_date BETWEEN p_start_date AND p_end_date
1009: );
1013: IS
1014: SELECT organization_id
1015: FROM hr_organization_units
1016: WHERE NAME = p_org_name
1017: AND business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
1018:
1019: -- The cursor to find the most recent 'assignment start date' for the effective date
1020: CURSOR c_asg_start_date
1021: IS
1036: FROM per_all_assignments_f asg
1037: ,hr_soft_coding_keyflex scl
1038: WHERE asg.assignment_id = p_assignment_id
1039: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1040: AND asg.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
1041: AND scl.segment1 = p_latest_org_id
1042: AND ( asg.effective_start_date BETWEEN p_start_date AND p_end_date
1043: OR
1044: asg.effective_end_date BETWEEN p_start_date AND p_end_date