DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on HR_GENERAL

Line 1884: , substr(hr_general.decode_lookup('PROPOSAL_REASON',g_cache_cwb_rpt_person (i).reason),1,30) -- bug : 7042887/10149579

1880: , g_cache_cwb_rpt_person (i).pay_basis_id
1881: , g_cache_cwb_rpt_person (i).element_entry_id
1882: , g_cache_cwb_rpt_person (i).exchange_rate
1883: , g_cache_cwb_rpt_person (i).effective_date
1884: , substr(hr_general.decode_lookup('PROPOSAL_REASON',g_cache_cwb_rpt_person (i).reason),1,30) -- bug : 7042887/10149579
1885: , g_cache_cwb_rpt_person (i).eligibility
1886: , g_cache_cwb_rpt_person (i).fte_factor
1887: , g_cache_cwb_rpt_person (i).element_input_value
1888: , nvl(g_cache_cwb_rpt_person (i).amount_posted,0)

Line 4181: l_perf_person_rec.performance_rating := substrb(hr_general.decode_lookup('PERFORMANCE_RATING',l_perf_txn.attribute3),1,30);

4177: end if;
4178:
4179: l_perf_person_rec.rating_date := l_perf_revw_strt_dt;
4180: l_perf_person_rec.rating_type := l_perf_txn.attribute2;
4181: l_perf_person_rec.performance_rating := substrb(hr_general.decode_lookup('PERFORMANCE_RATING',l_perf_txn.attribute3),1,30);
4182:
4183: if(l_error) then
4184: fnd_message.raise_error;
4185: end if;

Line 4235: l_perf_person_rec.rating_date := hr_general.end_of_time;

4231: g_actn := 'Person ' || p_person_id || ' failed for Performance Rating';
4232: WRITE (g_actn);
4233: END;
4234: ELSE
4235: l_perf_person_rec.rating_date := hr_general.end_of_time;
4236: l_perf_person_rec.status := 'SC';
4237: END IF;
4238: --
4239:

Line 4517: substrb(hr_general.decode_lookup('PERFORMANCE_RATING',l_posted_perf_rating),1,30);

4513: fetch c_posted_rating into l_posted_perf_rating;
4514: close c_posted_rating;
4515:
4516: l_perf_person_rec.posted_rating :=
4517: substrb(hr_general.decode_lookup('PERFORMANCE_RATING',l_posted_perf_rating),1,30);
4518:
4519: end if;
4520: IF(l_error) THEN
4521: l_perf_person_rec.status := 'E';