APPS.OKL_REPORT_GENERATOR_PVT dependencies on GL_PERIODS

Line 3467: ,gl_periods per

3463: IS
3464: SELECT gl.period_set_name period_set_name
3465: ,per.period_type period_type
3466: FROM gl_ledgers gl
3467: ,gl_periods per
3468: WHERE gl.ledger_id = p_ledger_id
3469: AND per.period_set_name = gl.period_set_name
3470: AND per.period_name = p_period_from;
3471:

Line 4815: FROM gl_periods per

4811: SET value1_text = 'GL_ACC_NON_SPEC_PERIOD'
4812: ,value12_text -- trx_period_name
4813: = (
4814: SELECT per.period_name
4815: FROM gl_periods per
4816: WHERE per.period_set_name = l_period_set_name
4817: AND per.START_DATE <= value1_date
4818: AND per.end_date >= value1_date
4819: AND per.adjustment_period_flag = 'N'

Line 5027: FROM gl_periods per

5023: -- Restrict the Journal Entries to be in between Start and End Dates
5024: AND gl.period_name IN
5025: (
5026: SELECT per.period_name
5027: FROM gl_periods per
5028: WHERE per.period_set_name = l_period_set_name
5029: AND per.START_DATE >= p_start_date
5030: AND per.end_date <= p_end_date
5031: AND per.adjustment_period_flag = 'N'

Line 6057: FROM gl_periods per

6053: KHR.ID KHR_ID,
6054: KLE.ID KLE_ID,
6055: STY.ID STY_ID,
6056: (SELECT per.period_name
6057: FROM gl_periods per
6058: WHERE per.period_set_name = (SELECT gl.period_set_name
6059: FROM gl_ledgers gl
6060: WHERE ledger_id = p_ledger_id)
6061: AND per.START_DATE <= STE.STREAM_ELEMENT_DATE

Line 6145: FROM gl_periods per

6141: KHR.ID KHR_ID,
6142: KLE.ID KLE_ID,
6143: STY.ID STY_ID,
6144: (SELECT per.period_name
6145: FROM gl_periods per
6146: WHERE per.period_set_name = (SELECT gl.period_set_name
6147: FROM gl_ledgers gl
6148: WHERE ledger_id = p_ledger_id)
6149: AND per.START_DATE <= STE.STREAM_ELEMENT_DATE

Line 6242: FROM gl_periods per

6238: TCL.LINE_NUMBER,
6239: TTY.ID TRY_ID,
6240: TTY.NAME TRANSACTION_TYPE,
6241: (SELECT per.period_name
6242: FROM gl_periods per
6243: WHERE per.period_set_name = (SELECT gl.period_set_name
6244: FROM gl_ledgers gl
6245: WHERE ledger_id = p_ledger_id)
6246: AND per.START_DATE <= TCN.TRANSACTION_DATE

Line 6302: FROM gl_periods per

6298: TCL.LINE_NUMBER,
6299: TTY.ID TRY_ID,
6300: TTY.NAME TRANSACTION_TYPE,
6301: (SELECT per.period_name
6302: FROM gl_periods per
6303: WHERE per.period_set_name = (SELECT gl.period_set_name
6304: FROM gl_ledgers gl
6305: WHERE ledger_id = p_ledger_id)
6306: AND per.START_DATE <= TCN.TRANSACTION_DATE

Line 6314: FROM gl_periods per

6310: FROM gl_ledgers gl
6311: WHERE ledger_id = p_ledger_id)
6312: ) TRANSACTION_PERIOD,
6313: (SELECT per.period_name
6314: FROM gl_periods per
6315: WHERE per.period_set_name = (SELECT gl.period_set_name
6316: FROM gl_ledgers gl
6317: WHERE ledger_id = p_ledger_id)
6318: AND per.START_DATE <= TCN.TRANSACTION_REVERSAL_DATE