[Home] [Help]
1394: -- Also added ppp.change_date <= p_effective_date to avoid getting the
1395: -- future dated salary rows.
1396: CURSOR c_gt_min IS
1397: SELECT MAX(ppp.change_date)
1398: FROM per_pay_proposals ppp, per_all_assignments_f paf
1399: WHERE paf.assignment_id = l_ass_rec.assignment_id
1400: and paf.assignment_type <> 'C'
1401: AND p_effective_date BETWEEN paf.effective_start_date
1402: AND paf.effective_end_date
1407: AND ppp.change_date <= p_effective_date ;
1408: --
1409: CURSOR c_gt_max IS
1410: SELECT MAX(ppp.change_date)
1411: FROM per_pay_proposals ppp, per_all_assignments_f paf
1412: WHERE paf.assignment_id = l_ass_rec.assignment_id
1413: and paf.assignment_type <> 'C'
1414: AND p_effective_date BETWEEN paf.effective_start_date
1415: AND paf.effective_end_date
1420: AND ppp.change_date <= p_effective_date;
1421: --
1422: CURSOR c_lt_max IS
1423: SELECT MAX(ppp.change_date)
1424: FROM per_pay_proposals ppp, per_all_assignments_f paf
1425: WHERE paf.assignment_id = l_ass_rec.assignment_id
1426: and paf.assignment_type <> 'C'
1427: AND p_effective_date BETWEEN paf.effective_start_date
1428: AND paf.effective_end_date
1433: AND ppp.change_date <= p_effective_date;
1434: --
1435: CURSOR c_lt_min IS
1436: SELECT MAX(ppp.change_date)
1437: FROM per_pay_proposals ppp, per_all_assignments_f paf
1438: WHERE paf.assignment_id = l_ass_rec.assignment_id
1439: and paf.assignment_type <> 'C'
1440: AND p_effective_date BETWEEN paf.effective_start_date
1441: AND paf.effective_end_date
1762: l_ass_rec per_all_assignments_f%ROWTYPE;
1763: --
1764: CURSOR c1 IS
1765: SELECT ppp.proposed_salary_n
1766: FROM per_pay_proposals ppp, per_all_assignments_f paf
1767: WHERE paf.assignment_id = l_ass_rec.assignment_id
1768: and paf.assignment_type <> 'C'
1769: AND paf.business_group_id = p_business_group_id
1770: AND p_effective_date BETWEEN paf.effective_start_date