APPS.FUN_TRX_PVT dependencies on GL_PERIOD_STATUSES

Line 1286: FROM GL_PERIOD_STATUSES PST

1282:
1283: ) IS
1284: CURSOR period_open_csr IS
1285: SELECT count(*)
1286: FROM GL_PERIOD_STATUSES PST
1287: WHERE pst.application_id = 435
1288: AND pst.closing_status <> 'N'
1289: AND pst.adjustment_period_flag <> 'Y'
1290: AND pst.ledger_id = p_from_le_id;

Line 1304: FROM GL_PERIOD_STATUSES PST

1300: , PST.PERIOD_YEAR
1301: , PST.PERIOD_NUM
1302: , PST.START_DATE
1303: , PST.END_DATE
1304: FROM GL_PERIOD_STATUSES PST
1305: , AR_SYSTEM_PARAMETERS SP
1306: WHERE PST.SET_OF_BOOKS_ID = SP.SET_OF_BOOKS_ID
1307: AND PST.APPLICATION_ID = 222
1308: AND PST.CLOSING_STATUS <> 'N'

Line 4530: FROM GL_PERIOD_STATUSES PST

4526:
4527: /* Removed as this should not be validated here
4528: CURSOR period_open_csr IS
4529: SELECT count(*)
4530: FROM GL_PERIOD_STATUSES PST
4531: WHERE pst.application_id = 200
4532: AND pst.closing_status <> 'N'
4533: AND pst.adjustment_period_flag <> 'Y'
4534: AND pst.ledger_id = p_to_le_id; */

Line 4659: FROM gl_period_statuses glps,

4655:
4656: CURSOR period_open_csr (p_trx_date DATE,
4657: p_ledger_id NUMBER) IS
4658: SELECT COUNT(*)
4659: FROM gl_period_statuses glps,
4660: gl_periods periods,
4661: gl_ledgers ledgers
4662: WHERE periods.period_set_name = ledgers.period_set_name
4663: AND TRUNC(p_trx_date) BETWEEN periods.start_date AND periods.end_date