APPS.BEN_CWB_WEBADI_UTILS dependencies on BNE_INTERFACE_COLS_B

Line 725: From bne_interface_cols_b

721: Return Varchar IS
722:
723: Cursor csr_is_options IS
724: Select '1'
725: From bne_interface_cols_b
726: where interface_code ='BEN_CWB_WRK_SHT_INTF'
727: And INTERFACE_COL_NAME like '%OPT%'
728: And application_id = 800
729: And SEQUENCE_NUM = p_inf_seq;

Line 733: From bne_interface_cols_b

729: And SEQUENCE_NUM = p_inf_seq;
730:
731: Cursor csr_opt1 IS
732: Select '1'
733: From bne_interface_cols_b
734: where interface_code ='BEN_CWB_WRK_SHT_INTF'
735: And INTERFACE_COL_NAME like '%OPT1%'
736: And application_id = 800
737: And SEQUENCE_NUM = p_inf_seq;

Line 741: From bne_interface_cols_b

737: And SEQUENCE_NUM = p_inf_seq;
738:
739: Cursor csr_opt2 IS
740: Select '1'
741: From bne_interface_cols_b
742: where interface_code ='BEN_CWB_WRK_SHT_INTF'
743: And INTERFACE_COL_NAME like '%OPT2%'
744: And application_id = 800
745: And SEQUENCE_NUM = p_inf_seq;

Line 749: From bne_interface_cols_b

745: And SEQUENCE_NUM = p_inf_seq;
746:
747: Cursor csr_opt3 IS
748: Select '1'
749: From bne_interface_cols_b
750: where interface_code ='BEN_CWB_WRK_SHT_INTF'
751: And INTERFACE_COL_NAME like '%OPT3%'
752: And application_id = 800
753: And SEQUENCE_NUM = p_inf_seq;

Line 757: From bne_interface_cols_b

753: And SEQUENCE_NUM = p_inf_seq;
754:
755: Cursor csr_opt4 IS
756: Select '1'
757: From bne_interface_cols_b
758: where interface_code ='BEN_CWB_WRK_SHT_INTF'
759: And INTERFACE_COL_NAME like '%OPT4%'
760: And application_id = 800
761: And SEQUENCE_NUM = p_inf_seq;

Line 1741: From bne_interface_cols_b InfCols,

1737:
1738: Cursor csr_col_prompt
1739: IS
1740: Select InfColsTl.prompt_left
1741: From bne_interface_cols_b InfCols,
1742: bne_interface_cols_tl InfColsTl
1743: Where InfCols.interface_code = p_interface_code
1744: And InfCols.INTERFACE_COL_NAME = p_interface_col_code
1745: And InfCols.application_id = 800

Line 1966: bne_interface_cols_b infCols,

1962: Select infCols.interface_col_name inf_col_name
1963: ,infCols.sequence_num inf_Seq_Num
1964: ,layCols.SEQUENCE_NUM Dis_Seq_Num
1965: From bne_interfaces_b inf,
1966: bne_interface_cols_b infCols,
1967: bne_layout_cols layCols,
1968: bne_layout_blocks_b layBlk
1969: Where inf.integrator_code = p_integrator_code
1970: And inf.integrator_app_id = 800

Line 1989: Bne_interface_cols_b infCols

1985: Select cust.ITEM_NAME inf_col_name
1986: ,infCols.SEQUENCE_NUM inf_Seq_Num
1987: ,cust.ORDR_NUM Dis_Seq_Num
1988: From BEN_CUSTOM_REGION_ITEMS cust,
1989: Bne_interface_cols_b infCols
1990: Where cust.CUSTOM_KEY = p_key
1991: And cust.REGION_CODE = p_integrator_code
1992: And cust.CUSTOM_TYPE = p_integrator_code
1993: And cust.ITEM_NAME = infCols.INTERFACE_COL_NAME