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.PER_RI_WORKBENCH_PKG dependencies on PER_BUSINESS_GROUPS

Line 413: set oa_flex_num = (select job_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )

409: ) Is
410: begin
411: if p_setup_sub_task_code = 'JOB' then
412: update bne_interface_cols_b
413: set oa_flex_num = (select job_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )
414: where interface_code like 'PER_RI_JOB_INTF' and val_type = 'KEYFLEX' and application_id = 800;
415: elsif p_setup_sub_task_code = 'POSITION' then
416: update bne_interface_cols_b
417: set oa_flex_num = (select position_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )

Line 417: set oa_flex_num = (select position_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )

413: set oa_flex_num = (select job_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )
414: where interface_code like 'PER_RI_JOB_INTF' and val_type = 'KEYFLEX' and application_id = 800;
415: elsif p_setup_sub_task_code = 'POSITION' then
416: update bne_interface_cols_b
417: set oa_flex_num = (select position_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )
418: where interface_code like 'PER_RI_POSITION_INTF' and val_type = 'KEYFLEX' and application_id = 800;
419: elsif p_setup_sub_task_code = 'GRADE' then
420: update bne_interface_cols_b
421: set oa_flex_num = (select grade_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )

Line 421: set oa_flex_num = (select grade_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )

417: set oa_flex_num = (select position_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )
418: where interface_code like 'PER_RI_POSITION_INTF' and val_type = 'KEYFLEX' and application_id = 800;
419: elsif p_setup_sub_task_code = 'GRADE' then
420: update bne_interface_cols_b
421: set oa_flex_num = (select grade_structure FROM per_business_groups WHERE business_group_id = p_business_group_id )
422: where interface_code like 'PER_RI_GRADE_INTF' and val_type = 'KEYFLEX' and application_id = 800;
423: end if;
424: end;
425: