APPS.JE_PT_GL_PFTLS_PKG dependencies on GL_PERIODS

Line 81: FROM gl_periods gp

77: AND gb.ledger_id= :p_ledger_id
78: AND gb.translated_flag is null
79: AND gb.period_name in
80: (SELECT gp.period_name
81: FROM gl_periods gp
82: WHERE gp.period_set_name=:p_period_set_name
83: AND gp.period_type=:p_period_type
84: AND gp.start_date between :gd_start_date
85: AND :gd_end_date)

Line 105: FROM gl_periods gp

101: AND gb.ledger_id=:p_ledger_id
102: AND gb.translated_flag is null
103: AND gb.period_name in
104: (SELECT gp.period_name
105: FROM gl_periods gp
106: WHERE gp.period_set_name=:p_period_set_name
107: AND gp.period_type=:p_period_type
108: AND gp.start_date between :gd_prior_start_date
109: AND :gd_prior_end_date)

Line 240: ,gl_periods gps

236: ,gn_prev_year
237: ,lc_period_type
238: FROM
239: gl_ledgers gll
240: ,gl_periods gps
241: ,gl_periods gpe
242: ,gl_periods gpps
243: ,gl_periods gppe
244: WHERE

Line 241: ,gl_periods gpe

237: ,lc_period_type
238: FROM
239: gl_ledgers gll
240: ,gl_periods gps
241: ,gl_periods gpe
242: ,gl_periods gpps
243: ,gl_periods gppe
244: WHERE
245: gll.ledger_id=p_ledger_id

Line 242: ,gl_periods gpps

238: FROM
239: gl_ledgers gll
240: ,gl_periods gps
241: ,gl_periods gpe
242: ,gl_periods gpps
243: ,gl_periods gppe
244: WHERE
245: gll.ledger_id=p_ledger_id
246: AND gps.period_name=p_start_period

Line 243: ,gl_periods gppe

239: gl_ledgers gll
240: ,gl_periods gps
241: ,gl_periods gpe
242: ,gl_periods gpps
243: ,gl_periods gppe
244: WHERE
245: gll.ledger_id=p_ledger_id
246: AND gps.period_name=p_start_period
247: AND gps.period_set_name=gll.period_set_name