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