eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIM_SET_OF_BOOKS dependencies on GL_PERIODS

Line 30: FROM gl_sets_of_books a, gl_periods b

26: IS
27: SELECT b.period_year year,
28: SUBSTR(b.entered_period_name, 0, 2) quarter,
29: TO_CHAR(p_input_date, 'MON') month
30: FROM gl_sets_of_books a, gl_periods b
31: WHERE a.set_of_books_id = (select set_of_books_id FROM
32: ozf_sys_parameters_all WHERE org_id = p_org_id)
33: AND b.period_set_name = a.period_set_name
34: AND b.period_type=quarter_type

Line 41: FROM gl_periods b

37: */
38: CURSOR period_month
39: IS
40: SELECT b.period_name, b.period_num
41: FROM gl_periods b
42: WHERE b.period_set_name = default_calender
43: AND b.period_type=month_type
44: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
45: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 50: FROM gl_periods b

46:
47: CURSOR period_quarter
48: IS
49: SELECT b.period_name, b.period_num
50: FROM gl_periods b
51: WHERE b.period_set_name = default_calender
52: AND b.period_type=quarter_type
53: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
54: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 59: FROM gl_periods b

55:
56: CURSOR period_year
57: IS
58: SELECT b.period_name
59: FROM gl_periods b
60: WHERE b.period_set_name = default_calender
61: AND b.period_type=year_type
62: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
63: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 140: FROM gl_periods b

136:
137: CURSOR period_info
138: IS
139: SELECT b.period_name
140: FROM gl_periods b
141: WHERE b.period_set_name = default_calender
142: --AND b.period_type=month_type
143: AND b.period_type=month_type
144: AND TRUNC(p_input_date) >= TRUNC(b.start_date)

Line 205: FROM gl_periods b

201:
202: CURSOR period_info
203: IS
204: SELECT b.period_name
205: FROM gl_periods b
206: WHERE b.period_set_name = default_calender
207: AND b.period_type=quarter_type
208: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
209: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 267: FROM gl_periods b

263:
264: CURSOR period_info
265: IS
266: SELECT b.period_name year
267: FROM gl_periods b
268: WHERE b.period_set_name = default_calender
269: AND b.period_type=year_type
270: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
271: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 332: FROM gl_periods b

328:
329: CURSOR period_info
330: IS
331: SELECT b.period_num period_num
332: FROM gl_periods b
333: WHERE b.period_set_name = default_calender
334: AND b.period_type=quarter_type
335: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
336: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 396: FROM gl_periods

392: l_name VARCHAR2(30);
393:
394: CURSOR period_name IS
395: SELECT period_name
396: FROM gl_periods
397: WHERE end_date =( SELECT start_date -1
398: FROM gl_periods
399: WHERE period_name =p_name
400: AND period_set_name = default_calender)

Line 398: FROM gl_periods

394: CURSOR period_name IS
395: SELECT period_name
396: FROM gl_periods
397: WHERE end_date =( SELECT start_date -1
398: FROM gl_periods
399: WHERE period_name =p_name
400: AND period_set_name = default_calender)
401: AND period_set_name = default_calender
402: AND UPPER(period_type) =p_type;

Line 463: FROM gl_periods b

459:
460: CURSOR period_info
461: IS
462: SELECT b.period_num period_num
463: FROM gl_periods b
464: WHERE b.period_set_name = default_calender
465: AND b.period_type=month_type
466: AND b.period_name =p_month;
467: BEGIN

Line 527: FROM gl_periods b

523:
524: CURSOR period_info
525: IS
526: SELECT b.period_num period_num
527: FROM gl_periods b
528: WHERE b.period_set_name = default_calender
529: AND b.period_type=month_type
530: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
531: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 593: FROM gl_sets_of_books a, gl_periods b

589: /*
590: CURSOR period_info(v_date DATE)
591: IS
592: SELECT b.start_date
593: FROM gl_sets_of_books a, gl_periods b
594: WHERE a.set_of_books_id = (select set_of_books_id FROM
595: ozf_sys_parameters_all WHERE org_id = p_org_id)
596: AND b.period_set_name = a.period_set_name
597: AND b.period_type=quarter_type

Line 604: FROM gl_periods b

600: */
601: CURSOR period_info(v_date DATE)
602: IS
603: SELECT b.start_date
604: FROM gl_periods b
605: WHERE b.period_set_name = default_calender
606: AND b.period_type=quarter_type
607: AND TRUNC(v_date) >= TRUNC(b.start_date)
608: AND TRUNC(v_date) <= TRUNC(b.end_date);

Line 803: FROM gl_sets_of_books a, gl_periods b

799: /*
800: CURSOR period_info
801: IS
802: SELECT b.start_date
803: FROM gl_sets_of_books a, gl_periods b
804: WHERE a.set_of_books_id = (select set_of_books_id FROM
805: ozf_sys_parameters_all WHERE org_id = p_org_id)
806: AND b.period_set_name = a.period_set_name
807: AND b.period_type=year_type

Line 814: FROM gl_periods b

810: */
811: CURSOR period_info
812: IS
813: SELECT b.start_date
814: FROM gl_periods b
815: WHERE b.period_set_name = default_calender
816: AND b.period_type=year_type
817: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
818: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 880: FROM gl_sets_of_books a, gl_periods b

876: /*
877: CURSOR period_info
878: IS
879: SELECT b.start_date
880: FROM gl_sets_of_books a, gl_periods b
881: WHERE a.set_of_books_id = (select set_of_books_id FROM
882: ozf_sys_parameters_all WHERE org_id = p_org_id)
883: AND b.period_set_name = a.period_set_name
884: AND b.period_type=quarter_type

Line 891: FROM gl_periods b

887: */
888: CURSOR period_info
889: IS
890: SELECT b.start_date
891: FROM gl_periods b
892: WHERE b.period_set_name = default_calender
893: AND b.period_type=quarter_type
894: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
895: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 959: FROM gl_sets_of_books a, gl_periods b

955: /*
956: CURSOR period_info
957: IS
958: SELECT b.start_date
959: FROM gl_sets_of_books a, gl_periods b
960: WHERE a.set_of_books_id = (select set_of_books_id FROM
961: ozf_sys_parameters_all WHERE org_id = p_org_id)
962: AND b.period_set_name = a.period_set_name
963: AND b.period_type=month_type

Line 970: FROM gl_periods b

966: */
967: CURSOR period_info
968: IS
969: SELECT b.start_date
970: FROM gl_periods b
971: WHERE b.period_set_name = default_calender
972: AND b.period_type=month_type
973: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
974: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 1342: FROM gl_sets_of_books a, gl_periods b

1338: /*
1339: CURSOR period_info
1340: IS
1341: SELECT b.end_date
1342: FROM gl_sets_of_books a, gl_periods b
1343: WHERE a.set_of_books_id = (select set_of_books_id FROM
1344: ozf_sys_parameters_all WHERE org_id = p_org_id)
1345: AND b.period_set_name = a.period_set_name
1346: AND b.period_type=month_type

Line 1353: FROM gl_periods b

1349: */
1350: CURSOR period_info
1351: IS
1352: SELECT b.end_date
1353: FROM gl_periods b
1354: WHERE b.period_set_name = default_calender
1355: AND b.period_type=month_type
1356: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
1357: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 1419: FROM gl_sets_of_books a, gl_periods b

1415: /*
1416: CURSOR period_info
1417: IS
1418: SELECT b.end_date
1419: FROM gl_sets_of_books a, gl_periods b
1420: WHERE a.set_of_books_id = (select set_of_books_id FROM
1421: ozf_sys_parameters_all WHERE org_id = p_org_id)
1422: AND b.period_set_name = a.period_set_name
1423: AND b.period_type=quarter_type

Line 1430: FROM gl_periods b

1426: */
1427: CURSOR period_info
1428: IS
1429: SELECT b.end_date
1430: FROM gl_periods b
1431: WHERE b.period_set_name = default_calender
1432: AND b.period_type=quarter_type
1433: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
1434: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 1496: FROM gl_sets_of_books a, gl_periods b

1492: /*
1493: CURSOR period_info
1494: IS
1495: SELECT b.end_date
1496: FROM gl_sets_of_books a, gl_periods b
1497: WHERE a.set_of_books_id = (select set_of_books_id FROM
1498: ozf_sys_parameters_all WHERE org_id = p_org_id)
1499: AND b.period_set_name = a.period_set_name
1500: AND b.period_type=year_type

Line 1507: FROM gl_periods b

1503: */
1504: CURSOR period_info
1505: IS
1506: SELECT b.end_date
1507: FROM gl_periods b
1508: WHERE b.period_set_name = default_calender
1509: AND b.period_type=year_type
1510: AND TRUNC(p_input_date) >= TRUNC(b.start_date)
1511: AND TRUNC(p_input_date) <= TRUNC(b.end_date);

Line 1573: FROM gl_periods b

1569:
1570: CURSOR cur_period_date
1571: IS
1572: SELECT b.start_date
1573: FROM gl_periods b
1574: WHERE b.period_set_name = default_calender
1575: AND b.period_type=month_type
1576: AND b.period_name =p_period_name;
1577:

Line 1581: FROM gl_periods b

1577:
1578: CURSOR cur_period_name(l_start_date DATE)
1579: IS
1580: SELECT b.period_name period_name
1581: FROM gl_periods b
1582: WHERE b.period_set_name = default_calender
1583: AND b.period_type=quarter_type
1584: AND TRUNC(l_start_date) >= TRUNC(b.start_date)
1585: AND TRUNC(l_start_date) <= TRUNC(b.end_date);

Line 1656: FROM gl_periods b

1652:
1653: CURSOR cur_period_date
1654: IS
1655: SELECT b.start_date
1656: FROM gl_periods b
1657: WHERE b.period_set_name = default_calender
1658: AND b.period_type=month_type
1659: AND b.period_name =p_period_name;
1660:

Line 1664: FROM gl_periods b

1660:
1661: CURSOR cur_period_name(l_start_date DATE)
1662: IS
1663: SELECT b.period_name period_name
1664: FROM gl_periods b
1665: WHERE b.period_set_name = default_calender
1666: AND b.period_type=year_type
1667: AND TRUNC(l_start_date) >= TRUNC(b.start_date)
1668: AND TRUNC(l_start_date) <= TRUNC(b.end_date);

Line 1739: FROM gl_periods b

1735:
1736: CURSOR cur_period_date
1737: IS
1738: SELECT b.start_date
1739: FROM gl_periods b
1740: WHERE b.period_set_name = default_calender
1741: AND b.period_type=quarter_type
1742: AND b.period_name =p_period_name;
1743:

Line 1747: FROM gl_periods b

1743:
1744: CURSOR cur_period_name(l_start_date DATE)
1745: IS
1746: SELECT b.period_name period_name
1747: FROM gl_periods b
1748: WHERE b.period_set_name = default_calender
1749: AND b.period_type=year_type
1750: AND TRUNC(l_start_date) >= TRUNC(b.start_date)
1751: AND TRUNC(l_start_date) <= TRUNC(b.end_date);