DBA Data[Home] [Help]

APPS.QLTSMENB dependencies on QLTNINRB

Line 86: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID2) ||

82: ' WHERE ' || x_value || ' = ' ||
83: V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID;
84:
85: if V_PK_ID2 is not null then
86: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID2) ||
87: ' = ' || V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID2;
88: if V_PK_ID3 is not null then
89: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID3) ||
90: ' = ' || V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID3;

Line 89: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID3) ||

85: if V_PK_ID2 is not null then
86: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID2) ||
87: ' = ' || V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID2;
88: if V_PK_ID3 is not null then
89: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID3) ||
90: ' = ' || V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID3;
91: end if;
92: end if;
93: if V_FK_ADD_WHERE is not null then