APPS.GMS_BILLING dependencies on PA_INVOICE_GROUP_TABLES

Line 2403: select /*+INDEX(a PA_INVOICE_GROUP_TABLES_N1)*/

2399: b.invoice_format_id = X_INV_FORMAT_ID
2400: order by b.start_position;
2401: /* Cursor to get the TABLES for the Group Column associated with the Invoice Format Details */
2402: CURSOR Table_Cursor(X_INV_FORMAT_ID NUMBER ) IS
2403: select /*+INDEX(a PA_INVOICE_GROUP_TABLES_N1)*/
2404: distinct a.text TABLE_TEXT
2405: from
2406: pa_invoice_group_tables a,
2407: pa_invoice_group_columns b,

Line 2406: pa_invoice_group_tables a,

2402: CURSOR Table_Cursor(X_INV_FORMAT_ID NUMBER ) IS
2403: select /*+INDEX(a PA_INVOICE_GROUP_TABLES_N1)*/
2404: distinct a.text TABLE_TEXT
2405: from
2406: pa_invoice_group_tables a,
2407: pa_invoice_group_columns b,
2408: pa_invoice_format_details c
2409: where
2410: b.invoice_group_column_id = c.invoice_group_column_id and