DBA Data[Home] [Help]

APPS.JA_CN_HRMS_EXPORT_PKG dependencies on GL_PERIODS

Line 267: FROM GL_PERIODS GP,

263: CURSOR acc_date_cur
264: IS
265: SELECT MIN(GP.START_DATE),
266: MAX(GP.END_DATE)
267: FROM GL_PERIODS GP,
268: GL_LEDGERS LED
269: WHERE LED.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
270: AND LED.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
271: AND LED.LEDGER_ID = pn_ledger_id --parameter: pn_ledger_id

Line 461: FROM GL_PERIODS GP,

457: CURSOR acc_date_cur
458: IS
459: SELECT MIN(GP.START_DATE),
460: MAX(GP.END_DATE)
461: FROM GL_PERIODS GP,
462: GL_LEDGERS LED
463: WHERE LED.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
464: AND LED.ACCOUNTED_PERIOD_TYPE = GP.PERIOD_TYPE
465: AND LED.LEDGER_ID = pn_ledger_id --parameter: pn_ledger_id