APPS.FV_PURGED_TREASURY_SYMBOLS dependencies on GL_PERIODS

Line 36: gbl_period_year gl_periods.period_year%type;

32: gbl_year_established number;
33: gbl_new_established_year number;
34: gbl_request_id Number;
35: gbl_prelim_req_id Number;
36: gbl_period_year gl_periods.period_year%type;
37: gbl_period_set_name Gl_Ledgers_public_v.period_set_name%type;
38: g_module_name VARCHAR2(100) := 'fv.plsql.fv_purged_treasury_symbols.';
39: gbl_cursor_cnt NUMBER := 0;
40: gbl_acct_segment_num NUMBER;

Line 807: FROM gl_periods

803:
804: --- sysdate := megan date;
805: SELECT period_year
806: INTO p_year
807: FROM gl_periods
808: WHERE period_set_name = gbl_period_set_name
809: AND adjustment_period_flag = 'N'
810: GROUP BY PERIOD_YEAR
811: HAVING sysdate between min(start_date) and max(end_date);