DBA Data[Home] [Help]

APPS.PA_PACCGLER_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 43: L_NAME GL_SETS_OF_BOOKS.NAME%TYPE;

39: RETURN (TRUE);
40: END AFTERREPORT;
41:
42: PROCEDURE GET_COMPANY_NAME IS
43: L_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
44: BEGIN
45: SELECT
46: GL.NAME
47: INTO L_NAME

Line 49: GL_SETS_OF_BOOKS GL,

45: SELECT
46: GL.NAME
47: INTO L_NAME
48: FROM
49: GL_SETS_OF_BOOKS GL,
50: PA_IMPLEMENTATIONS PI
51: WHERE GL.SET_OF_BOOKS_ID = PI.SET_OF_BOOKS_ID;
52: C_COMPANY_NAME_HEADER := L_NAME;
53: EXCEPTION

Line 105: GL_SETS_OF_BOOKS GL,

101: SELECT
102: GL.CURRENCY_CODE
103: INTO L_CURR_CODE
104: FROM
105: GL_SETS_OF_BOOKS GL,
106: PA_IMPLEMENTATIONS IMP
107: WHERE IMP.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID;
108: RETURN (L_CURR_CODE);
109: EXCEPTION