DBA Data[Home] [Help]

APPS.JL_JLCOGLNA_XMLP_PKG dependencies on GL_PERIODS

Line 64: GL_PERIODS GLP,

60: GLP.PERIOD_NUM,
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;

Line 84: GL_PERIODS GLP,

80: GLP.PERIOD_NUM,
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;