[Home] [Help]
276: --
277: cursor csr_asg_effective_end_date is
278: select max(effective_end_date)
279: from per_all_assignments_f asg,
280: per_assignment_status_types ast
281: where asg.assignment_id = p_assignment_id
282: and asg.assignment_status_type_id=ast.assignment_status_type_id
283: and ast.per_system_status='ACTIVE_ASSIGN';
284:
602: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
603: l_payroll_status per_time_periods.status%TYPE;
604: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
605: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
606: l_system_status per_assignment_status_types.per_system_status%TYPE;
607: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
608: l_change_date per_pay_proposals.change_date%TYPE;
609: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
610: --
645: asg.pay_basis_id,
646: asg.payroll_id
647: from per_all_assignments_f asg,
648: per_time_periods ptp,
649: per_assignment_status_types ast
650: where asg.assignment_id = p_assignment_id
651: and asg.assignment_status_type_id = ast.assignment_status_type_id
652: and p_change_date between asg.effective_start_date
653: and asg.effective_end_date
991: --
992: cursor csr_valid_assg_status is
993: select null
994: from per_all_assignments_f assg,
995: per_assignment_status_types ast
996: where assg.assignment_id = p_assignment_id
997: and assg.assignment_status_type_id = ast.assignment_status_type_id
998: and assg.business_group_id + 0 = p_business_group_id
999: and p_next_sal_review_date between assg.effective_start_date
1150: --
1151: cursor csr_valid_assg_status is
1152: select null
1153: from per_all_assignments_f assg,
1154: per_assignment_status_types ast
1155: where assg.assignment_id = p_assignment_id
1156: and assg.assignment_status_type_id = ast.assignment_status_type_id
1157: and assg.business_group_id + 0 = p_business_group_id
1158: and p_next_sal_review_date between assg.effective_start_date