1261: -- Cursors to bring back first occurence where min or max was crossed
1262: --
1263: CURSOR c_gt_min IS
1264: SELECT MIN(pbb.effective_start_date)
1265: FROM ben_per_bnfts_bal_f pbb
1266: WHERE pbb.val >= p_min
1267: AND pbb.bnfts_bal_id = p_bnfts_bal_id
1268: AND p_effective_date BETWEEN pbb.effective_start_date
1269: AND pbb.effective_end_date
1270: AND pbb.person_id = p_person_id;
1271: --
1272: CURSOR c_gt_max IS
1273: SELECT MIN(pbb.effective_start_date)
1274: FROM ben_per_bnfts_bal_f pbb
1275: WHERE pbb.val > p_max
1276: AND pbb.bnfts_bal_id = p_bnfts_bal_id
1277: AND p_effective_date BETWEEN pbb.effective_start_date
1278: AND pbb.effective_end_date
1279: AND pbb.person_id = p_person_id;
1280: --
1281: CURSOR c_lt_max IS
1282: SELECT MIN(pbb.effective_start_date)
1283: FROM ben_per_bnfts_bal_f pbb
1284: WHERE pbb.val <= p_max
1285: AND pbb.bnfts_bal_id = p_bnfts_bal_id
1286: AND p_effective_date BETWEEN pbb.effective_start_date
1287: AND pbb.effective_end_date
1288: AND pbb.person_id = p_person_id;
1289: --
1290: CURSOR c_lt_min IS
1291: SELECT MIN(pbb.effective_start_date)
1292: FROM ben_per_bnfts_bal_f pbb
1293: WHERE pbb.val < p_min
1294: AND pbb.bnfts_bal_id = p_bnfts_bal_id
1295: AND p_effective_date BETWEEN pbb.effective_start_date
1296: AND pbb.effective_end_date
3055: l_oipl_rec ben_oipl_f%ROWTYPE;
3056: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3057: l_loc_rec hr_locations_all%ROWTYPE;
3058: l_ass_rec per_all_assignments_f%ROWTYPE;
3059: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
3060: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;
3061: l_jurisdiction_code VARCHAR2(30);
3062: l_assignment_action_id number;
3063:
3402: l_oipl_rec ben_oipl_f%ROWTYPE;
3403: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3404: l_loc_rec hr_locations_all%ROWTYPE;
3405: l_ass_rec per_all_assignments_f%ROWTYPE;
3406: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
3407: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;
3408: l_jurisdiction_code VARCHAR2(30);
3409: l_assignment_action_id number;
3410: --