APPS.GMF_SUBLEDGER_PKG dependencies on GL_PERIODS

Line 739: gl_periods glp,

735: cp_fiscal_year NUMBER)
736: IS
737: SELECT DISTINCT glp.period_year
738: FROM
739: gl_periods glp,
740: gl_period_sets gps,
741: gl_sets_of_books gsb
742: WHERE
743: glp.period_year = cp_fiscal_year

Line 758: gl_periods glp,

754: IS
755: SELECT glp.period_name, glp.period_year, glp.period_num,
756: glp.start_date, glp.end_date, sts.closing_status
757: FROM
758: gl_periods glp,
759: gl_period_statuses sts,
760: gl_sets_of_books gsob
761: WHERE
762: glp.period_set_name = gsob.period_set_name -- use the sob period-name

Line 786: l_gl_period_name gl_periods.period_name%TYPE;

782: l_open_gl_date DATE;
783: l_posting_start_date DATE;
784: l_posting_end_date DATE;
785:
786: l_gl_period_name gl_periods.period_name%TYPE;
787: l_gl_period_year gl_periods.period_year%TYPE;
788: l_gl_period_num gl_periods.period_num%TYPE;
789:
790: l_gl_per_start_date DATE;

Line 787: l_gl_period_year gl_periods.period_year%TYPE;

783: l_posting_start_date DATE;
784: l_posting_end_date DATE;
785:
786: l_gl_period_name gl_periods.period_name%TYPE;
787: l_gl_period_year gl_periods.period_year%TYPE;
788: l_gl_period_num gl_periods.period_num%TYPE;
789:
790: l_gl_per_start_date DATE;
791: l_gl_per_real_start_date DATE;

Line 788: l_gl_period_num gl_periods.period_num%TYPE;

784: l_posting_end_date DATE;
785:
786: l_gl_period_name gl_periods.period_name%TYPE;
787: l_gl_period_year gl_periods.period_year%TYPE;
788: l_gl_period_num gl_periods.period_num%TYPE;
789:
790: l_gl_per_start_date DATE;
791: l_gl_per_real_start_date DATE;
792: l_gl_per_end_date DATE;