APPS.JL_JLCOGLNA_XMLP_PKG dependencies on JL_CO_GL_BALANCES

Line 111: PN JL_CO_GL_BALANCES.PERIOD_NAME%TYPE;

107: FUNCTION C_BEGINBALFORMULA(ACCOUNT IN VARCHAR2
108: ,NIT_ID IN NUMBER) RETURN NUMBER IS
109: BEGIN
110: DECLARE
111: PN JL_CO_GL_BALANCES.PERIOD_NAME%TYPE;
112: ACODE JL_CO_GL_BALANCES.ACCOUNT_CODE%TYPE;
113: BBDR NUMBER;
114: BBCR NUMBER;
115: PNDR NUMBER;

Line 112: ACODE JL_CO_GL_BALANCES.ACCOUNT_CODE%TYPE;

108: ,NIT_ID IN NUMBER) RETURN NUMBER IS
109: BEGIN
110: DECLARE
111: PN JL_CO_GL_BALANCES.PERIOD_NAME%TYPE;
112: ACODE JL_CO_GL_BALANCES.ACCOUNT_CODE%TYPE;
113: BBDR NUMBER;
114: BBCR NUMBER;
115: PNDR NUMBER;
116: PNCR NUMBER;

Line 130: JL_CO_GL_BALANCES BAL

126: SUM(BAL.PERIOD_NET_CR),
127: BAL.ACCOUNT_CODE
128: INTO PN,BBDR,BBCR,PNDR,PNCR,ACODE
129: FROM
130: JL_CO_GL_BALANCES BAL
131: WHERE BAL.NIT_ID = NIT_ID
132: AND BAL.ACCOUNT_CODE = ACCOUNT
133: AND BAL.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
134: AND ( BAL.PERIOD_YEAR * 100 + BAL.PERIOD_NUM ) = (

Line 138: JL_CO_GL_BALANCES B1,

134: AND ( BAL.PERIOD_YEAR * 100 + BAL.PERIOD_NUM ) = (
135: SELECT
136: MAX(B1.PERIOD_YEAR * 100 + B1.PERIOD_NUM)
137: FROM
138: JL_CO_GL_BALANCES B1,
139: GL_CODE_COMBINATIONS GLCC
140: WHERE BAL.SET_OF_BOOKS_ID = B1.SET_OF_BOOKS_ID
141: AND BAL.ACCOUNT_CODE = B1.ACCOUNT_CODE
142: AND B1.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID