eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PER_BNFTS_BAL_F

Line 1264: FROM ben_per_bnfts_bal_f pbb

1260: -- Cursors to bring back first occurence where min or max was crossed
1261: --
1262: CURSOR c_gt_min IS
1263: SELECT MIN(pbb.effective_start_date)
1264: FROM ben_per_bnfts_bal_f pbb
1265: WHERE pbb.val >= p_min
1266: AND pbb.bnfts_bal_id = p_bnfts_bal_id
1267: AND p_effective_date BETWEEN pbb.effective_start_date
1268: AND pbb.effective_end_date

Line 1273: FROM ben_per_bnfts_bal_f pbb

1269: AND pbb.person_id = p_person_id;
1270: --
1271: CURSOR c_gt_max IS
1272: SELECT MIN(pbb.effective_start_date)
1273: FROM ben_per_bnfts_bal_f pbb
1274: WHERE pbb.val > p_max
1275: AND pbb.bnfts_bal_id = p_bnfts_bal_id
1276: AND p_effective_date BETWEEN pbb.effective_start_date
1277: AND pbb.effective_end_date

Line 1282: FROM ben_per_bnfts_bal_f pbb

1278: AND pbb.person_id = p_person_id;
1279: --
1280: CURSOR c_lt_max IS
1281: SELECT MIN(pbb.effective_start_date)
1282: FROM ben_per_bnfts_bal_f pbb
1283: WHERE pbb.val <= p_max
1284: AND pbb.bnfts_bal_id = p_bnfts_bal_id
1285: AND p_effective_date BETWEEN pbb.effective_start_date
1286: AND pbb.effective_end_date

Line 1291: FROM ben_per_bnfts_bal_f pbb

1287: AND pbb.person_id = p_person_id;
1288: --
1289: CURSOR c_lt_min IS
1290: SELECT MIN(pbb.effective_start_date)
1291: FROM ben_per_bnfts_bal_f pbb
1292: WHERE pbb.val < p_min
1293: AND pbb.bnfts_bal_id = p_bnfts_bal_id
1294: AND p_effective_date BETWEEN pbb.effective_start_date
1295: AND pbb.effective_end_date

Line 3058: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;

3054: l_oipl_rec ben_oipl_f%ROWTYPE;
3055: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3056: l_loc_rec hr_locations_all%ROWTYPE;
3057: l_ass_rec per_all_assignments_f%ROWTYPE;
3058: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
3059: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;
3060: l_jurisdiction_code VARCHAR2(30);
3061: l_assignment_action_id number;
3062:

Line 3405: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;

3401: l_oipl_rec ben_oipl_f%ROWTYPE;
3402: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3403: l_loc_rec hr_locations_all%ROWTYPE;
3404: l_ass_rec per_all_assignments_f%ROWTYPE;
3405: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
3406: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;
3407: l_jurisdiction_code VARCHAR2(30);
3408: l_assignment_action_id number;
3409: --