APPS.PER_RI_WORKBENCH_PKG dependencies on BNE_INTERFACE_COLS_B

Line 412: update bne_interface_cols_b

408: ,p_business_group_id In Number
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

Line 416: update bne_interface_cols_b

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 )
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

Line 420: update bne_interface_cols_b

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 )
422: where interface_code like 'PER_RI_GRADE_INTF' and val_type = 'KEYFLEX' and application_id = 800;
423: end if;
424: end;