APPS.XLA_TB_AP_REPORT_PVT dependencies on GL_PERIODS

Line 1244: FROM gl_ledgers gl , gl_periods gp

1240:
1241: -- add TB phase4 bug#7600550 bug#8278138
1242: CURSOR c_latest_open_period IS
1243: SELECT latest_opened_period_name , gp.start_date
1244: FROM gl_ledgers gl , gl_periods gp
1245: where ledger_id = p_ledger_id
1246: AND gp.period_set_name = gl.period_set_name
1247: AND gp.period_type = gl.accounted_period_type
1248: AND NVL(gp.adjustment_period_flag,'N')='N'

Line 1269: l_latest_opened_period_name gl_periods.period_name%TYPE;

1265: AND NVL(adjustment_period_flag,'N')='N'
1266: AND closing_status = 'O'
1267: );
1268:
1269: l_latest_opened_period_name gl_periods.period_name%TYPE;
1270: l_start_date gl_periods.start_date%TYPE;
1271:
1272:
1273:

Line 1270: l_start_date gl_periods.start_date%TYPE;

1266: AND closing_status = 'O'
1267: );
1268:
1269: l_latest_opened_period_name gl_periods.period_name%TYPE;
1270: l_start_date gl_periods.start_date%TYPE;
1271:
1272:
1273:
1274: BEGIN

Line 1319: ,gl_periods gp

1315: /*
1316: SELECT gp.period_name
1317: INTO l_period_name
1318: FROM gl_ledgers gl
1319: ,gl_periods gp
1320: WHERE gl.ledger_id = p_ledger_id
1321: AND gp.period_set_name = gl.period_set_name
1322: AND gp.period_type = gl.accounted_period_type
1323: AND NVL(TRUNC(l_as_of_date),TRUNC(sysdate)) BETWEEN gp.start_date AND gp.end_date

Line 1346: ,gl_periods gp

1342:
1343: SELECT gp.period_name
1344: INTO l_period_name
1345: FROM gl_ledgers gl
1346: ,gl_periods gp
1347: WHERE gl.ledger_id = p_ledger_id
1348: AND gp.period_set_name = gl.period_set_name
1349: AND gp.period_type = gl.accounted_period_type
1350: AND NVL(TRUNC(l_as_of_date),TRUNC(sysdate)) BETWEEN gp.start_date AND gp.end_date