APPS.JTF_TAE_SQL_LIB_PVT dependencies on JTF_TAE_SQL_LIB_PVT

Line 1: PACKAGE BODY jtf_tae_sql_lib_pvt AS

1: PACKAGE BODY jtf_tae_sql_lib_pvt AS
2: /* $Header: jtfvtslb.pls 120.0 2005/06/02 18:23:04 appldev ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTF_TAE_SQL_LIB_PVT

Line 5: -- PACKAGE NAME: JTF_TAE_SQL_LIB_PVT

1: PACKAGE BODY jtf_tae_sql_lib_pvt AS
2: /* $Header: jtfvtslb.pls 120.0 2005/06/02 18:23:04 appldev ship $ */
3: -- Start of Comments
4: -- ---------------------------------------------------
5: -- PACKAGE NAME: JTF_TAE_SQL_LIB_PVT
6: -- ---------------------------------------------------
7: -- PURPOSE
8: -- This is to store the commonly used (hand-tuned) SQL
9: -- used by the TAE Generation Program

Line 2169: lp_close_outermost_ILV := ') A; -- jtf_tae_sql_lib_pvt_nm826 line 841 ';

2165: G_INDENT || ' , ILV.top_level_terr_id '|| g_newline ||
2166: G_INDENT || ' , ILV.num_winners ' || g_newline;
2167:
2168:
2169: lp_close_outermost_ILV := ') A; -- jtf_tae_sql_lib_pvt_nm826 line 841 ';
2170: ELSE
2171: l_select_ilv2 :=
2172: G_INDENT5 || 'SELECT DISTINCT ' || g_newline ||
2173: G_INDENT5 ||'ILV2.trans_object_id' || g_newline ||

Line 2542: lp_close_outermost_ILV := ') A; -- jtf_tae_sql_lib_pvt_nm826 line 841 ';

2538: G_INDENT || ' , ILV.top_level_terr_id '|| g_newline ||
2539: G_INDENT || ' , ILV.num_winners ' || g_newline;
2540:
2541:
2542: lp_close_outermost_ILV := ') A; -- jtf_tae_sql_lib_pvt_nm826 line 841 ';
2543: ELSE
2544: l_select_ilv2 :=
2545: G_INDENT5 || 'SELECT DISTINCT ' || g_newline ||
2546: G_INDENT5 ||'ILV2.trans_object_id' || g_newline ||

Line 3465: lp_close_outermost_ILV := ') A; -- jtf_tae_sql_lib_pvt_nm826 line 841 ';

3461: G_INDENT || ' , ILV.top_level_terr_id '|| g_newline ||
3462: G_INDENT || ' , ILV.num_winners ' || g_newline;
3463:
3464:
3465: lp_close_outermost_ILV := ') A; -- jtf_tae_sql_lib_pvt_nm826 line 841 ';
3466: ELSE
3467: l_select_ilv2 :=
3468: G_INDENT5 || 'SELECT DISTINCT ' || g_newline ||
3469: G_INDENT5 ||'ILV2.trans_object_id' || g_newline ||

Line 7031: END JTF_TAE_SQL_LIB_PVT;

7027:
7028: END get_qual_comb_sql;
7029:
7030:
7031: END JTF_TAE_SQL_LIB_PVT;