APPS.JA_CN_SIOA_EXPORT_PKG dependencies on GL_PERIODS

Line 73: GL_PERIODS GP,

69: ,pv_period_to VARCHAR2*/)
70: IS
71: SELECT DISTINCT JCAB.ACCOUNT_SEGMENT --Account Number
72: FROM JA_CN_ACCOUNT_BALANCES JCAB,
73: GL_PERIODS GP,
74: GL_LEDGERS LED
75: WHERE JCAB.LEDGER_ID = pn_ledger_id --parameter: pn_ledger_id
76: AND JCAB.LEGAL_ENTITY_ID = pn_legal_entity_id --parameter: pn_legal_entity_id
77: AND JCAB.PERIOD_NAME = GP.PERIOD_NAME

Line 84: FROM GL_PERIODS GP

80: AND LED.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
81: AND GP.PERIOD_YEAR = TO_NUMBER(pv_accounting_year) --parameter: pv_accounting_year
82: /* AND GP.START_DATE BETWEEN
83: (SELECT START_DATE
84: FROM GL_PERIODS GP
85: WHERE LED.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
86: AND LED.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
87: AND GP.PERIOD_NAME = pv_period_from) --parameter: pv_period_from
88: AND (SELECT START_DATE

Line 89: FROM GL_PERIODS GP

85: WHERE LED.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
86: AND LED.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
87: AND GP.PERIOD_NAME = pv_period_from) --parameter: pv_period_from
88: AND (SELECT START_DATE
89: FROM GL_PERIODS GP
90: WHERE LED.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
91: AND LED.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
92: AND GP.PERIOD_NAME = pv_period_to) --parameter: pv_period_to*/
93: ORDER BY JCAB.ACCOUNT_SEGMENT;

Line 136: GL_PERIODS GP,

132: ,MAX(JCAB.SEGMENT28) SEGMENT28
133: ,MAX(JCAB.SEGMENT29) SEGMENT29
134: ,MAX(JCAB.SEGMENT30) SEGMENT30
135: FROM JA_CN_ACCOUNT_BALANCES JCAB,
136: GL_PERIODS GP,
137: GL_LEDGERS LED
138: WHERE JCAB.LEDGER_ID = pn_ledger_id --parameter: pn_ledger_id
139: AND JCAB.LEGAL_ENTITY_ID = pn_legal_entity_id --parameter: pn_legal_entity_id
140: AND JCAB.PERIOD_NAME = GP.PERIOD_NAME

Line 148: FROM GL_PERIODS GP

144: AND GP.PERIOD_YEAR = TO_NUMBER(pv_accounting_year) --parameter: pv_accounting_year
145: AND JCAB.ACCOUNT_SEGMENT = lv_account_number --Account Number
146: /* AND GP.START_DATE BETWEEN
147: (SELECT START_DATE
148: FROM GL_PERIODS GP
149: WHERE LED.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
150: AND LED.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
151: AND GP.PERIOD_NAME = pv_period_from) --parameter: pv_period_from
152: AND (SELECT START_DATE

Line 153: FROM GL_PERIODS GP

149: WHERE LED.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
150: AND LED.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
151: AND GP.PERIOD_NAME = pv_period_from) --parameter: pv_period_from
152: AND (SELECT START_DATE
153: FROM GL_PERIODS GP
154: WHERE LED.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
155: AND LED.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
156: AND GP.PERIOD_NAME = pv_period_to) --parameter: pv_period_to*/
157: ;