APPS.IGI_IGIPCBAP_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 45: GL_SETS_OF_BOOKS GSOB

41: GSOB.CURRENCY_CODE
42: INTO LP_END_DATE,LP_CURRENCY_CODE
43: FROM
44: GL_PERIODS GP,
45: GL_SETS_OF_BOOKS GSOB
46: WHERE GSOB.SET_OF_BOOKS_ID = P_SOB_ID
47: AND GSOB.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
48: AND GP.PERIOD_NAME = P_TO_PERIOD;
49: IF P_FROM_PERIOD IS NOT NULL THEN

Line 55: GL_SETS_OF_BOOKS GSOB

51: GP.START_DATE
52: INTO LP_START_DATE
53: FROM
54: GL_PERIODS GP,
55: GL_SETS_OF_BOOKS GSOB
56: WHERE GSOB.SET_OF_BOOKS_ID = P_SOB_ID
57: AND GSOB.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
58: AND GP.PERIOD_NAME = P_FROM_PERIOD;
59: ELSE

Line 65: GL_SETS_OF_BOOKS GSOB

61: GP.START_DATE
62: INTO LP_START_DATE
63: FROM
64: GL_PERIODS GP,
65: GL_SETS_OF_BOOKS GSOB
66: WHERE GSOB.SET_OF_BOOKS_ID = P_SOB_ID
67: AND GSOB.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
68: AND GP.PERIOD_NUM = 1
69: AND GP.PERIOD_TYPE = GSOB.ACCOUNTED_PERIOD_TYPE

Line 75: GL_SETS_OF_BOOKS GS

71: SELECT
72: G.PERIOD_YEAR
73: FROM
74: GL_PERIODS G,
75: GL_SETS_OF_BOOKS GS
76: WHERE GS.SET_OF_BOOKS_ID = P_SOB_ID
77: AND GS.PERIOD_SET_NAME = G.PERIOD_SET_NAME
78: AND G.PERIOD_NAME = P_TO_PERIOD );
79: END IF;

Line 110: L_NAME GL_SETS_OF_BOOKS.NAME%TYPE;

106: RETURN (TRUE);
107: END AFTERREPORT;
108:
109: FUNCTION CF_SOB_NAMEFORMULA RETURN CHAR IS
110: L_NAME GL_SETS_OF_BOOKS.NAME%TYPE;
111: BEGIN
112: SELECT
113: NAME
114: INTO L_NAME

Line 116: GL_SETS_OF_BOOKS

112: SELECT
113: NAME
114: INTO L_NAME
115: FROM
116: GL_SETS_OF_BOOKS
117: WHERE SET_OF_BOOKS_ID = P_SOB_ID;
118: RETURN (L_NAME);
119: EXCEPTION
120: WHEN NO_DATA_FOUND THEN