DBA Data[Home] [Help]

APPS.GL_CONS_HISTORY_PKG dependencies on GL_PERIOD_STATUSES

Line 61: FROM gl_period_statuses

57: ) IS
58: BEGIN
59: SELECT period_name, start_date, closing_status
60: INTO PeriodName, StartDate, ClosingStatus
61: FROM gl_period_statuses
62: WHERE application_id = 101
63: AND ledger_id = LedgerId
64: AND adjustment_period_flag = 'N'
65: AND quarter_num = QuarterNum

Line 84: FROM gl_period_statuses

80: ) IS
81: BEGIN
82: SELECT period_name, start_date, closing_status
83: INTO PeriodName, StartDate, ClosingStatus
84: FROM gl_period_statuses
85: WHERE application_id = 101
86: AND ledger_id = LedgerId
87: AND adjustment_period_flag = 'N'
88: AND period_year = PeriodYear

Line 890: GL_PERIOD_STATUSES PS,

886: X_Target_Resp_Name,
887: X_Target_User_Name,
888: X_Target_DB_Name
889: FROM
890: GL_PERIOD_STATUSES PS,
891: GL_BUDGET_PERIOD_RANGES BPR
892: WHERE BPR.budget_version_id = X_From_Budget_Version_Id
893: AND BPR.period_year = X_Period_Year
894: AND BPR.open_flag = 'O'