APPS.FV_1219_TRANSACTIONS dependencies on GL_SETS_OF_BOOKS

Line 3786: FROM gl_periods glp, gl_sets_of_books gsob

3782: BEGIN
3783:
3784: SELECT end_date
3785: INTO l_accomplish_date
3786: FROM gl_periods glp, gl_sets_of_books gsob
3787: WHERE glp.period_name = l_gl_period
3788: AND glp.period_type = period_type
3789: AND gsob.set_of_books_id = p_set_bks_id
3790: AND gsob.chart_of_accounts_id = flex_num

Line 3937: FROM GL_PERIODS glp, GL_SETS_OF_BOOKS gsob

3933:
3934: BEGIN
3935: SELECT start_date, end_date
3936: INTO l_start_date2, l_end_date2
3937: FROM GL_PERIODS glp, GL_SETS_OF_BOOKS gsob
3938: WHERE glp.period_name = l_gl_period_name
3939: AND glp.period_type = period_type
3940: AND gsob.set_of_books_id = p_set_bks_id
3941: AND gsob.chart_of_accounts_id = flex_num

Line 4581: FROM gl_sets_of_books

4577: WHERE rownum = 1;
4578:
4579: SELECT chart_of_accounts_id
4580: INTO flex_num
4581: FROM gl_sets_of_books
4582: WHERE set_of_books_id = p_set_bks_id;
4583:
4584: SELECT end_date
4585: INTO l_end_date

Line 4587: gl_sets_of_books gsob

4583:
4584: SELECT end_date
4585: INTO l_end_date
4586: FROM gl_periods glp,
4587: gl_sets_of_books gsob
4588: WHERE glp.period_name = p_gl_period
4589: AND gsob.set_of_books_id = p_set_bks_id
4590: AND gsob.chart_of_accounts_id = flex_num
4591: AND glp.period_set_name = gsob.period_set_name;

Line 5024: FROM gl_sets_of_books

5020: WHERE rownum = 1;
5021:
5022: SELECT chart_of_accounts_id
5023: INTO flex_num
5024: FROM gl_sets_of_books
5025: WHERE set_of_books_id = p_set_bks_id;
5026:
5027: SELECT end_date
5028: INTO l_end_date

Line 5030: gl_sets_of_books gsob

5026:
5027: SELECT end_date
5028: INTO l_end_date
5029: FROM gl_periods glp,
5030: gl_sets_of_books gsob
5031: WHERE glp.period_name = v_period
5032: AND gsob.set_of_books_id = p_set_bks_id
5033: AND gsob.chart_of_accounts_id = flex_num
5034: AND glp.period_set_name = gsob.period_set_name;