[Home] [Help]
533: p_ws_sub_acty_typ_cd in varchar2) return varchar2
534: Is
535: --- ws_nmmntry_uom need to be decode from lookup table
536: Cursor cur_option1_units is
537: Select decode(ws_nnmntry_uom,null,currency, hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom) )
538: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
539: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
540: And bcpd.group_pl_id = p_group_plan_id
541: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
831: p_ws_sub_acty_typ_cd in varchar2) return varchar2
832: Is
833: ----- ws_nnmntry_uom needs to be decoded from lookup table
834: Cursor cur_option2_units is
835: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
836: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
837: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
838: And bcpd.group_pl_id = p_group_plan_id
839: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1130: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1131: Is
1132: -- ws_nnmntry_uom needs to be decoded from lookup table
1133: Cursor cur_option3_units is
1134: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1135: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1136: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1137: And bcpd.group_pl_id = p_group_plan_id
1138: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
1426: p_ws_sub_acty_typ_cd in varchar2) return varchar2
1427: Is
1428: -- ws_nnmntry_uom needs to be decoded from lookup table
1429: Cursor cur_option4_units is
1430: Select decode(ws_nnmntry_uom,null,currency,hr_general.decode_lookup('BEN_NNMNTRY_UOM',ws_nnmntry_uom))
1431: From ben_cwb_person_rates bcpr,ben_cwb_pl_dsgn bcpd
1432: Where bcpr.group_per_in_ler_id = p_group_per_in_ler_id
1433: And bcpd.group_pl_id = p_group_plan_id
1434: And bcpd.lf_evt_ocrd_dt = p_lf_evnt_ocrd_dt
2060:
2061: BEGIN
2062:
2063: --IF (nvl(g_asgn_txn_rec.assignment_id,-1) <> p_assignment_id OR
2064: -- 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
2065:
2066: g_asgn_txn_rec := null;
2067: OPEN g_cursor_asgn_txn (p_assignment_id, to_char(p_asg_updt_eff_date,'RRRR/MM/DD'));
2068: FETCH g_cursor_asgn_txn into g_asgn_txn_rec;
2077: begin
2078: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2079:
2080: if ( g_asgn_txn_rec.job_id is not null) then
2081: return ( hr_general.decode_job(g_asgn_txn_rec.job_id));
2082: end if;
2083:
2084: return null;
2085: end get_new_job;
2090: begin
2091: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2092: -- Using DECODE_POSITION_LATEST_NAME instead of DECODE_POSITION : Anadi
2093: if ( g_asgn_txn_rec.position_id is not null) then
2094: return ( hr_general.DECODE_POSITION_LATEST_NAME(g_asgn_txn_rec.position_id));
2095: end if;
2096:
2097: return null;
2098: end get_new_position;
2103: begin
2104: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2105:
2106: if ( g_asgn_txn_rec.grade_id is not null) then
2107: return ( hr_general.decode_grade (g_asgn_txn_rec.grade_id));
2108: end if;
2109:
2110: return null;
2111: end get_new_grade ;
2117: begin
2118: populate_asgn_txn_rec (p_assignment_id, p_asg_updt_eff_date);
2119:
2120: if ( g_asgn_txn_rec.people_group_id is not null) then
2121: return ( hr_general.decode_people_group (g_asgn_txn_rec.people_group_id));
2122: end if;
2123:
2124: return null;
2125: end get_new_people_group ;
2205: p_perf_revw_strt_dt in date,
2206: p_emp_interview_typ_cd in varchar2 ) return varchar2 IS
2207:
2208: CURSOR c_perf_rate is
2209: select hr_general.decode_lookup('PERFORMANCE_RATING',attribute3)
2210: From ben_transaction
2211: where transaction_id = p_assignment_id
2212: and transaction_type = 'CWBPERF'||to_char(p_perf_revw_strt_dt,'rrrr/mm/dd')
2213: ||p_emp_interview_typ_cd;