DBA Data[Home] [Help]

APPS.HRI_APL_DGNSTC_WRKFC dependencies on HR_BIS

Line 259: l_wmv_type := hr_bis.bis_decode_lookup('BUDGET_MEASUREMENT_TYPE', l_wmv_type_code);

255: l_wmv_type_code := 'HEAD';
256: END IF;
257:
258: -- Lookup the type
259: l_wmv_type := hr_bis.bis_decode_lookup('BUDGET_MEASUREMENT_TYPE', l_wmv_type_code);
260:
261: l_sql_stmt :=
262: 'SELECT /*+ parallel(asg) parallel(suph) */
263: per.full_name person

Line 516: hr_bis.bis_decode_lookup(''EMP_APL'', asg.assignment_type) meaning

512: BEGIN
513:
514: l_sql_stmt :=
515: 'SELECT /*+ parallel(asg) */
516: hr_bis.bis_decode_lookup(''EMP_APL'', asg.assignment_type) meaning
517: ,count(*) total
518: ,null col3
519: ,null col4
520: ,null col5