APPS.PQP_PERASGADD_RIW dependencies on BNE_INTERFACE_COLS_B

Line 658: from bne_interface_cols_b bic

654: return per_all_people_f%rowtype is
655:
656: cursor bne_cols(c_interface_code in varchar2) is
657: select lower(bic.interface_col_name) interface_col_name
658: from bne_interface_cols_b bic
659: where bic.interface_code = c_interface_code
660: and bic.display_flag ='Y';
661: --and bic.interface_col_type <> 2;
662:

Line 666: from bne_interface_cols_b bic

662:
663: -- Added by pkagrawa to query cols which are not displayed (DFF segments)
664: cursor bne_cols_no_disp(c_interface_code in varchar2) is
665: select lower(bic.interface_col_name) interface_col_name
666: from bne_interface_cols_b bic
667: where bic.interface_code = c_interface_code
668: and bic.display_flag ='N';
669:
670: l_per_rec per_all_people_f%rowtype;

Line 1077: from bne_interface_cols_b bic

1073: return per_all_assignments_f%rowtype is
1074:
1075: cursor bne_cols(c_interface_code in varchar2) is
1076: select lower(bic.interface_col_name) interface_col_name
1077: from bne_interface_cols_b bic
1078: where bic.interface_code = c_interface_code
1079: and bic.display_flag ='Y';
1080:
1081: -- Added by Dbansal to query cols which are not displayed (DFF segments)

Line 1084: from bne_interface_cols_b bic

1080:
1081: -- Added by Dbansal to query cols which are not displayed (DFF segments)
1082: cursor bne_cols_no_disp(c_interface_code in varchar2) is
1083: select lower(bic.interface_col_name) interface_col_name
1084: from bne_interface_cols_b bic
1085: where bic.interface_code = c_interface_code
1086: and bic.display_flag ='N';
1087:
1088: l_proc_name constant varchar2(150) := g_pkg||'Get_AsgRecord_Values';

Line 1353: from bne_interface_cols_b bic

1349: return pay_people_groups%rowtype is
1350:
1351: cursor bne_cols(c_interface_code in varchar2) is
1352: select lower(bic.interface_col_name) interface_col_name
1353: from bne_interface_cols_b bic
1354: where bic.interface_code = c_interface_code
1355: and bic.group_name = 'PEOPLE_KEYFLEX_GROUP'
1356: and bic.display_flag ='Y';
1357: --If the concat segments column is included then each segment value is assigned to the passed value.

Line 1519: from bne_interface_cols_b bic

1515: return hr_soft_coding_keyflex%rowtype is
1516:
1517: cursor bne_cols(c_interface_code in varchar2) is
1518: select lower(bic.interface_col_name) interface_col_name
1519: from bne_interface_cols_b bic
1520: where bic.interface_code = c_interface_code
1521: and bic.SEQUENCE_NUM between 222 and 252 --$ All soft coded KFF segments
1522: -- and (bic.group_name = 'SOFT_KEYFLEX_GROUP' or
1523: -- lower(bic.interface_col_name) ='p_gre');