[Home] [Help]
1040: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1041: Is
1042: --- ws_nmmntry_uom need to be decode from lookup table
1043: Cursor cur_option1_units is
1044: Select decode(ws_nnmntry_uom,null,currency, hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom) )
1045: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1046: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1047: And bcpd.group_pl_id = p_group_plan_id
1048: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1338: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1339: Is
1340: ----- ws_nnmntry_uom needs to be decoded from lookup table
1341: Cursor cur_option2_units is
1342: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1343: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1344: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1345: And bcpd.group_pl_id = p_group_plan_id
1346: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1637: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1638: Is
1639: -- ws_nnmntry_uom needs to be decoded from lookup table
1640: Cursor cur_option3_units is
1641: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1642: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1643: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1644: And bcpd.group_pl_id = p_group_plan_id
1645: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1933: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1934: Is
1935: -- ws_nnmntry_uom needs to be decoded from lookup table
1936: Cursor cur_option4_units is
1937: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1938: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1939: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1940: And bcpd.group_pl_id = p_group_plan_id
1941: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
2567:
2568: BEGIN
2569:
2570: --IF (nvl(g_asgn_txn_rec.assignment_id,-1) <> p_assignment_id OR
2571: -- nvl(to_date(g_asgn_txn_rec.asg_updt_eff_date,'RRRR/MM/DD'),hr_general.start_of_time ) <> p_asg_updt_eff_date ) THEN
2572:
2573: g_asgn_txn_rec := null;
2574: OPEN g_cursor_asgn_txn (p_assignment_id, to_char(p_asg_updt_eff_date,'RRRR/MM/DD'));
2575: FETCH g_cursor_asgn_txn into g_asgn_txn_rec;
2584: begin
2585: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2586:
2587: if ( g_asgn_txn_rec.job_id is not null) then
2588: return ( hr_general.decode_job(g_asgn_txn_rec.job_id));
2589: end if;
2590:
2591: return null;
2592: end get_new_job;
2597: begin
2598: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2599: -- Using DECODE_POSITION_LATEST_NAME instead of DECODE_POSITION : Anadi
2600: if ( g_asgn_txn_rec.position_id is not null) then
2601: return ( hr_general.DECODE_POSITION_LATEST_NAME(g_asgn_txn_rec.position_id));
2602: end if;
2603:
2604: return null;
2605: end get_new_position;
2610: begin
2611: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2612:
2613: if ( g_asgn_txn_rec.grade_id is not null) then
2614: return ( hr_general.decode_grade (g_asgn_txn_rec.grade_id));
2615: end if;
2616:
2617: return null;
2618: end get_new_grade ;
2624: begin
2625: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2626:
2627: if ( g_asgn_txn_rec.people_group_id is not null) then
2628: return ( hr_general.decode_people_group (g_asgn_txn_rec.people_group_id));
2629: end if;
2630:
2631: return null;
2632: end get_new_people_group ;
2712: p_perf_revw_strt_dt in date,
2713: p_emp_interview_typ_cd in varchar2 ) return varchar2 IS
2714:
2715: CURSOR c_perf_rate is
2716: select hr_general.decode_lookup('PERFORMANCE_RATING',attribute3)
2717: From ben_transaction
2718: where transaction_id = p_assignment_id
2719: and transaction_type = 'CWBPERF'||to_char(p_perf_revw_strt_dt,'rrrr/mm/dd')
2720: ||p_emp_interview_typ_cd;