APPS.GMS_BILLING dependencies on PA_INV_GRP_WHR_CLAUSES

Line 2415: select /*+INDEX(b PA_INV_GRP_WHR_CLAUSES_U1)*/

2411: a.invoice_group_column_id = c.invoice_group_column_id and
2412: c.invoice_format_id = X_INV_FORMAT_ID;
2413: /* Cursor to get the WHERE for the Group Column associated with the Invoice Format Details */
2414: CURSOR Where_Cursor(X_INV_FORMAT_ID NUMBER) IS
2415: select /*+INDEX(b PA_INV_GRP_WHR_CLAUSES_U1)*/
2416: distinct b.text WHERE_TEXT
2417: from
2418: pa_inv_grp_col_whr_clauses a,
2419: pa_inv_grp_whr_clauses b,

Line 2419: pa_inv_grp_whr_clauses b,

2415: select /*+INDEX(b PA_INV_GRP_WHR_CLAUSES_U1)*/
2416: distinct b.text WHERE_TEXT
2417: from
2418: pa_inv_grp_col_whr_clauses a,
2419: pa_inv_grp_whr_clauses b,
2420: pa_invoice_group_columns c,
2421: pa_invoice_format_details d
2422: where
2423: b.invoice_group_where_clause_id = a.invoice_group_where_clause_id and