APPS.JL_JLCOGLNA_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 65: GL_SETS_OF_BOOKS GLS

61: GLP.PERIOD_YEAR
62: INTO P_NUM,P_YEAR
63: FROM
64: GL_PERIODS GLP,
65: GL_SETS_OF_BOOKS GLS
66: WHERE GLP.PERIOD_NAME = P_START_PERIOD
67: AND GLP.PERIOD_SET_NAME = GLS.PERIOD_SET_NAME
68: AND GLS.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
69: C_PNUM2 := P_NUM;

Line 85: GL_SETS_OF_BOOKS GLS

81: GLP.PERIOD_YEAR
82: INTO P_NUM1,P_YEAR1
83: FROM
84: GL_PERIODS GLP,
85: GL_SETS_OF_BOOKS GLS
86: WHERE GLP.PERIOD_NAME = P_END_PERIOD
87: AND GLP.PERIOD_SET_NAME = GLS.PERIOD_SET_NAME
88: AND GLS.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
89: C_PNUM3 := P_NUM1;