275: --
276: cursor csr_asg_effective_end_date is
277: select max(effective_end_date)
278: from per_all_assignments_f asg,
279: per_assignment_status_types ast
280: where asg.assignment_id = p_assignment_id
281: and asg.assignment_status_type_id=ast.assignment_status_type_id
282: and ast.per_system_status='ACTIVE_ASSIGN';
283:
622: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
623: l_payroll_status per_time_periods.status%TYPE;
624: l_assginment_id per_all_assignments_f.assignment_id%TYPE;
625: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
626: l_system_status per_assignment_status_types.per_system_status%TYPE;
627: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
628: l_change_date per_pay_proposals.change_date%TYPE;
629: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
630: --
665: asg.pay_basis_id,
666: asg.payroll_id
667: from per_all_assignments_f asg,
668: per_time_periods ptp,
669: per_assignment_status_types ast
670: where asg.assignment_id = p_assignment_id
671: and asg.assignment_status_type_id = ast.assignment_status_type_id
672: and p_change_date between asg.effective_start_date
673: and asg.effective_end_date
1016: --
1017: cursor csr_valid_assg_status is
1018: select null
1019: from per_all_assignments_f assg,
1020: per_assignment_status_types ast
1021: where assg.assignment_id = p_assignment_id
1022: and assg.assignment_status_type_id = ast.assignment_status_type_id
1023: and assg.business_group_id + 0 = p_business_group_id
1024: and p_next_sal_review_date between assg.effective_start_date
1175: --
1176: cursor csr_valid_assg_status is
1177: select null
1178: from per_all_assignments_f assg,
1179: per_assignment_status_types ast
1180: where assg.assignment_id = p_assignment_id
1181: and assg.assignment_status_type_id = ast.assignment_status_type_id
1182: and assg.business_group_id + 0 = p_business_group_id
1183: and p_next_sal_review_date between assg.effective_start_date