602:
603: select distinct paa_other.assignment_id,
604: paa_other.assignment_action_id
605: from pay_assignment_actions paa_current,
606: per_all_assignments_f paaf_current,
607: pay_assignment_actions paa_other,
608: per_all_assignments_f paaf_other
609: where paa_current.payroll_action_id = c_arch_pay_action_id
610: and paa_current.assignment_action_id = c_arch_asg_action_id
604: paa_other.assignment_action_id
605: from pay_assignment_actions paa_current,
606: per_all_assignments_f paaf_current,
607: pay_assignment_actions paa_other,
608: per_all_assignments_f paaf_other
609: where paa_current.payroll_action_id = c_arch_pay_action_id
610: and paa_current.assignment_action_id = c_arch_asg_action_id
611: and paaf_current.assignment_id = paa_current.assignment_id
612: and paa_other.payroll_action_id = c_arch_pay_action_id
1140: cursor csr_asg (c_arch_payroll_action_id number) is
1141: select distinct paa.assignment_id
1142: from pay_assignment_actions paa,
1143: pay_action_information pai,
1144: per_all_assignments_f paaf
1145: where paa.payroll_action_id = c_arch_payroll_action_id
1146: and pai.action_context_id = paa.assignment_action_id
1147: -- and pai.action_information_category = 'GB_RTI_ASG_DETAILS'
1148: and pai.action_information_category = 'GB RTI EMPLOYEE DETAILS'