APPS.JL_JLCOGLAN_XMLP_PKG dependencies on JL_CO_GL_BALANCES

Line 47: PN JL_CO_GL_BALANCES.PERIOD_NAME%TYPE;

43: FUNCTION C_CCIDFORMULA(NIT IN NUMBER
44: ,ACCOUNT IN VARCHAR2) RETURN NUMBER IS
45: BEGIN
46: DECLARE
47: PN JL_CO_GL_BALANCES.PERIOD_NAME%TYPE;
48: ACODE JL_CO_GL_BALANCES.ACCOUNT_CODE%TYPE;
49: BBDR NUMBER;
50: BBCR NUMBER;
51: PNDR NUMBER;

Line 48: ACODE JL_CO_GL_BALANCES.ACCOUNT_CODE%TYPE;

44: ,ACCOUNT IN VARCHAR2) RETURN NUMBER IS
45: BEGIN
46: DECLARE
47: PN JL_CO_GL_BALANCES.PERIOD_NAME%TYPE;
48: ACODE JL_CO_GL_BALANCES.ACCOUNT_CODE%TYPE;
49: BBDR NUMBER;
50: BBCR NUMBER;
51: PNDR NUMBER;
52: PNCR NUMBER;

Line 64: JL_CO_GL_BALANCES BAL

60: SUM(BAL.PERIOD_NET_CR),
61: BAL.ACCOUNT_CODE
62: INTO PN,BBDR,BBCR,PNDR,PNCR,ACODE
63: FROM
64: JL_CO_GL_BALANCES BAL
65: WHERE BAL.NIT_ID = NIT
66: AND BAL.ACCOUNT_CODE = ACCOUNT
67: AND BAL.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
68: AND ( BAL.PERIOD_YEAR * 100 + BAL.PERIOD_NUM ) = (

Line 72: JL_CO_GL_BALANCES B1,

68: AND ( BAL.PERIOD_YEAR * 100 + BAL.PERIOD_NUM ) = (
69: SELECT
70: MAX(B1.PERIOD_YEAR * 100 + B1.PERIOD_NUM)
71: FROM
72: JL_CO_GL_BALANCES B1,
73: GL_CODE_COMBINATIONS GLCC
74: WHERE BAL.SET_OF_BOOKS_ID = B1.SET_OF_BOOKS_ID
75: AND BAL.ACCOUNT_CODE = B1.ACCOUNT_CODE
76: AND B1.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID