APPS.PQP_PERASGADD_RIW dependencies on BNE_INTERFACE_COLS_B

Line 657: from bne_interface_cols_b bic

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

Line 665: from bne_interface_cols_b bic

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

Line 1076: from bne_interface_cols_b bic

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

Line 1083: from bne_interface_cols_b bic

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

Line 1352: from bne_interface_cols_b bic

1348: return pay_people_groups%rowtype is
1349:
1350: cursor bne_cols(c_interface_code in varchar2) is
1351: select lower(bic.interface_col_name) interface_col_name
1352: from bne_interface_cols_b bic
1353: where bic.interface_code = c_interface_code
1354: and bic.group_name = 'PEOPLE_KEYFLEX_GROUP';
1355: --$ Commented this as segments value is not passed due to this flag
1356: -- and bic.display_flag ='Y';

Line 1513: from bne_interface_cols_b bic

1509: return hr_soft_coding_keyflex%rowtype is
1510:
1511: cursor bne_cols(c_interface_code in varchar2) is
1512: select lower(bic.interface_col_name) interface_col_name
1513: from bne_interface_cols_b bic
1514: where bic.interface_code = c_interface_code
1515: and bic.SEQUENCE_NUM between 222 and 252; --$ All soft coded KFF segments
1516: -- and (bic.group_name = 'SOFT_KEYFLEX_GROUP' or
1517: -- lower(bic.interface_col_name) ='p_gre');