APPS.BEN_CWB_WS_IMPORT_PKG dependencies on BNE_INTERFACE_COLS_B

Line 919: from bne_interface_cols_b intf, bne_layout_cols lay

915:
916: cursor csr_is_read_only (l_seq1 in number,l_seq2 in number,l_seq3 in number,
917: l_seq4 in number,l_seq5 in number, l_seq6 in number) is
918: select interface_seq_num, decode(nvl(lay.read_only_flag,'N')||nvl(intf.read_only_flag,'N'), 'NN','N','Y') read_only
919: from bne_interface_cols_b intf, bne_layout_cols lay
920: where intf.interface_code = nvl(p_interface_code,'BEN_CWB_WRK_SHT_INTF')
921: and intf.application_id = 800
922: and intf.interface_code = lay.interface_code
923: and lay.layout_code = nvl(p_base_layout_code,'BEN_CWB_WRK_SHT_BASE_LYT')

Line 1363: from bne_interface_cols_b intf, bne_layout_cols lay

1359:
1360: cursor csr_is_read_only (l_intf in varchar2,
1361: l_base_layout in varchar2) is
1362: select interface_seq_num, decode(nvl(lay.read_only_flag,'N')||nvl(intf.read_only_flag,'N'), 'NN','N','Y') read_only
1363: from bne_interface_cols_b intf, bne_layout_cols lay
1364: where intf.interface_code = nvl(l_intf,'BEN_CWB_WRK_SHT_INTF')
1365: and intf.application_id = 800
1366: and intf.interface_code = lay.interface_code
1367: and lay.layout_code = nvl(l_base_layout,'BEN_CWB_WRK_SHT_BASE_LYT')

Line 1372: l_interfac_code bne_interface_cols_b.interface_code%TYPE;

1368: and lay.application_id = 800
1369: and intf.sequence_num = lay.interface_seq_num
1370: and ((intf.sequence_num between 200 and 234) or (intf.sequence_num between 136 and 150));
1371:
1372: l_interfac_code bne_interface_cols_b.interface_code%TYPE;
1373: l_base_layout_code bne_layout_cols.layout_code%TYPE;
1374: l_is_read_only csr_is_read_only%RowType;
1375: l_pl_ws_val BEN_CWB_PERSON_RATES.WS_VAL%Type;
1376: l_group_per_in_ler_id BEN_CWB_PERSON_RATES.GROUP_PER_IN_LER_ID%Type;