APPS.FUN_TRX_PVT dependencies on GL_PERIOD_STATUSES

Line 1225: FROM GL_PERIOD_STATUSES PST

1221:
1222: ) IS
1223: CURSOR period_open_csr IS
1224: SELECT count(*)
1225: FROM GL_PERIOD_STATUSES PST
1226: WHERE pst.application_id = 435
1227: AND pst.closing_status <> 'N'
1228: AND pst.adjustment_period_flag <> 'Y'
1229: AND pst.ledger_id = p_from_le_id;

Line 1243: FROM GL_PERIOD_STATUSES PST

1239: , PST.PERIOD_YEAR
1240: , PST.PERIOD_NUM
1241: , PST.START_DATE
1242: , PST.END_DATE
1243: FROM GL_PERIOD_STATUSES PST
1244: , AR_SYSTEM_PARAMETERS SP
1245: WHERE PST.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID
1246: AND PST.APPLICATION_ID = 222
1247: AND PST.CLOSING_STATUS <> 'N'

Line 4234: FROM GL_PERIOD_STATUSES PST

4230:
4231: /* Removed as this should not be validated here
4232: CURSOR period_open_csr IS
4233: SELECT count(*)
4234: FROM GL_PERIOD_STATUSES PST
4235: WHERE pst.application_id = 200
4236: AND pst.closing_status <> 'N'
4237: AND pst.adjustment_period_flag <> 'Y'
4238: AND pst.ledger_id = p_to_le_id; */

Line 4358: FROM gl_period_statuses glps,

4354:
4355: CURSOR period_open_csr (p_trx_date DATE,
4356: p_ledger_id NUMBER) IS
4357: SELECT COUNT(*)
4358: FROM gl_period_statuses glps,
4359: gl_periods periods,
4360: gl_ledgers ledgers
4361: WHERE periods.period_set_name = ledgers.period_set_name
4362: AND TRUNC(p_trx_date) BETWEEN periods.start_date AND periods.end_date