DBA Data[Home] [Help]

APPS.GL_TRANS_STATUSES_PKG dependencies on GL_PERIOD_STATUSES

Line 43: FROM GL_PERIOD_STATUSES PS

39: AND TS.AVERAGE_TRANSLATION_FLAG = decode(x_usage_code, 'A', 'Y', 'N')
40: AND TS.ACTUAL_FLAG = 'A'
41: AND TS.period_name IN
42: ( SELECT PS.period_name
43: FROM GL_PERIOD_STATUSES PS
44: WHERE PS.application_id = 101
45: AND PS.ledger_id = x_ledger_id
46: AND PS.effective_period_num >=
47: (x_period_year * 10000 + x_period_num));