DBA Data[Home] [Help]

APPS.GL_PERIOD_STATUSES_PKG dependencies on GL_PERIOD_TYPES

Line 600: gl_period_types pt

596: and ps.application_id = x_application_id
597: and ps.period_name in
598: (select period_name
599: from gl_period_statuses ps1,
600: gl_period_types pt
601: where v_period_type = pt.period_type
602: and ps1.application_id = x_application_id
603: and ps1.ledger_id = x_ledger_id
604: and ps1.period_type = pt.period_type

Line 653: GL_PERIOD_TYPES GPT

649: PS2.start_date
650: FROM GL_LEDGERS LED,
651: GL_PERIOD_STATUSES PS1,
652: GL_PERIOD_STATUSES PS2,
653: GL_PERIOD_TYPES GPT
654: WHERE PS1.application_id = x_application_id
655: AND PS1.closing_status || '' in ('C', 'P')
656: AND PS1.ledger_id = x_ledger_id
657: AND PS1.period_type = GPT.period_type