APPS.PA_ALLOC_RUN dependencies on GL_SETS_OF_BOOKS

Line 2607: , gl_sets_of_books b

2603: SELECT a.set_of_books_id
2604: , b.accounted_period_type
2605: , b.currency_code
2606: FROM pa_implementations a
2607: , gl_sets_of_books b
2608: WHERE a.set_of_books_id = b.set_of_books_id;
2609: CURSOR gl_eligible_amount IS
2610: SELECT nvl(sum( nvl(eligible_amount,0)*DECODE(subtract_flag,'Y',-1,1) ),0)
2611: FROM pa_alloc_run_GL_det

Line 4448: gl_sets_of_books a,

4444: Cursor C_fy_qtr is
4445: select decode(p_run_period_type,'PA', b.pa_period_type, a.accounted_period_type),
4446: a.period_set_name,glp.period_year,glp.quarter_num,glp.period_num,end_date
4447: from gl_periods glp,
4448: gl_sets_of_books a,
4449: pa_implementations b
4450: where a.set_of_books_id = b.set_of_books_id
4451: and glp.period_set_name = a.period_set_name
4452: and glp.period_type = decode(p_run_period_type,'PA', b.pa_period_type,