13: ORG_ID,
14: SET_OF_BOOKS_ID
15: INTO P_ORG_ID,P_SOB_ID
16: FROM
17: PA_IMPLEMENTATIONS;
18: SELECT
19: START_DATE,
20: END_DATE
21: INTO P_FIRST_DATE,P_LAST_DATE
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
54: WHEN OTHERS THEN
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
110: WHEN NO_DATA_FOUND THEN