APPS.BEN_CWB_WEBADI_UTILS dependencies on BNE_INTERFACE_COLS_B

Line 732: From bne_interface_cols_b

728: Return Varchar IS
729:
730: Cursor csr_is_options IS
731: Select '1'
732: From bne_interface_cols_b
733: where (substr(interface_code,1,15)='BEN_CWB_WS_INTF'
734: OR interface_code = 'BEN_CWB_WRK_SHT_INTF')
735: And INTERFACE_COL_NAME like '%OPT%'
736: AND interface_code = g_interface_code

Line 742: From bne_interface_cols_b

738: And SEQUENCE_NUM = p_inf_seq;
739:
740: Cursor csr_opt1 IS
741: Select '1'
742: From bne_interface_cols_b
743: where (substr(interface_code,1,15) ='BEN_CWB_WS_INTF'
744: OR interface_code = 'BEN_CWB_WRK_SHT_INTF')
745: And INTERFACE_COL_NAME like '%OPT1%'
746: AND interface_code = g_interface_code

Line 752: From bne_interface_cols_b

748: And SEQUENCE_NUM = p_inf_seq;
749:
750: Cursor csr_opt2 IS
751: Select '1'
752: From bne_interface_cols_b
753: where (substr(interface_code,1,15) ='BEN_CWB_WS_INTF'
754: OR interface_code = 'BEN_CWB_WRK_SHT_INTF')
755: AND interface_code = g_interface_code
756: And INTERFACE_COL_NAME like '%OPT2%'

Line 762: From bne_interface_cols_b

758: And SEQUENCE_NUM = p_inf_seq;
759:
760: Cursor csr_opt3 IS
761: Select '1'
762: From bne_interface_cols_b
763: where (substr(interface_code,1,15) ='BEN_CWB_WS_INTF'
764: OR interface_code = 'BEN_CWB_WRK_SHT_INTF')
765: AND interface_code = g_interface_code
766: And INTERFACE_COL_NAME like '%OPT3%'

Line 772: From bne_interface_cols_b

768: And SEQUENCE_NUM = p_inf_seq;
769:
770: Cursor csr_opt4 IS
771: Select '1'
772: From bne_interface_cols_b
773: where (substr(interface_code,1,15) ='BEN_CWB_WS_INTF'
774: OR interface_code = 'BEN_CWB_WRK_SHT_INTF')
775: AND interface_code = g_interface_code
776: And INTERFACE_COL_NAME like '%OPT4%'

Line 789: From bne_interface_cols_b

785: and asg_updt_eff_date is not null;
786:
787: Cursor csr_promotions IS
788: Select '1'
789: From bne_interface_cols_b
790: where (substr(interface_code,1,15) ='BEN_CWB_WS_INTF'
791: OR interface_code = 'BEN_CWB_WRK_SHT_INTF')
792: AND interface_code = g_interface_code
793: And SEQUENCE_NUM in (126,152,191,192)

Line 1243: from bne_interface_cols_b bic,

1239: AND blc.interface_seq_num = p_inf_seq;
1240:
1241: /*cursor csr_interface_cols_row is
1242: select bic.read_only_flag
1243: from bne_interface_cols_b bic,
1244: bne_layout_cols blc
1245: where blc.application_id = p_application_id
1246: and blc.layout_code = p_base_layout_code
1247: and blc.interface_seq_num = p_inf_seq

Line 1858: From bne_interface_cols_b InfCols,

1854:
1855: Cursor csr_col_prompt
1856: IS
1857: Select InfColsTl.prompt_left
1858: From bne_interface_cols_b InfCols,
1859: bne_interface_cols_tl InfColsTl
1860: Where InfCols.interface_code = p_interface_code
1861: And InfCols.INTERFACE_COL_NAME = p_interface_col_code
1862: And InfCols.application_id = 800

Line 2095: bne_interface_cols_b infCols,

2091: Select infCols.interface_col_name inf_col_name
2092: ,infCols.sequence_num inf_Seq_Num
2093: ,layCols.SEQUENCE_NUM Dis_Seq_Num
2094: From bne_interfaces_b inf,
2095: bne_interface_cols_b infCols,
2096: bne_layout_cols layCols,
2097: bne_layout_blocks_b layBlk
2098: Where inf.integrator_code = p_integrator_code
2099: And inf.integrator_app_id = 800

Line 2118: Bne_interface_cols_b infCols

2114: Select cust.ITEM_NAME inf_col_name
2115: ,infCols.SEQUENCE_NUM inf_Seq_Num
2116: ,cust.ORDR_NUM Dis_Seq_Num
2117: From BEN_CUSTOM_REGION_ITEMS cust,
2118: Bne_interface_cols_b infCols
2119: Where cust.CUSTOM_KEY = p_key
2120: And cust.REGION_CODE = p_region_key --p_integrator_code
2121: And cust.CUSTOM_TYPE = p_integrator_code
2122: And cust.ITEM_NAME = infCols.INTERFACE_COL_NAME