DBA Data[Home] [Help]

APPS.GL_PERIOD_STATUSES_PKG dependencies on GL_PERIOD_TYPES

Line 644: gl_period_types pt

640: and ps.application_id = x_application_id
641: and ps.period_name in
642: (select period_name
643: from gl_period_statuses ps1,
644: gl_period_types pt
645: where v_period_type = pt.period_type
646: and ps1.application_id = x_application_id
647: and ps1.ledger_id = x_ledger_id
648: and ps1.period_type = pt.period_type

Line 697: GL_PERIOD_TYPES GPT

693: PS2.start_date
694: FROM GL_LEDGERS LED,
695: GL_PERIOD_STATUSES PS1,
696: GL_PERIOD_STATUSES PS2,
697: GL_PERIOD_TYPES GPT
698: WHERE PS1.application_id = x_application_id
699: AND PS1.closing_status || '' in ('C', 'P')
700: AND PS1.ledger_id = x_ledger_id
701: AND PS1.period_type = GPT.period_type