APPS.PA_ALLOC_RUN dependencies on GL_SETS_OF_BOOKS

Line 2617: , gl_sets_of_books b

2613: SELECT a.set_of_books_id
2614: , b.accounted_period_type
2615: , b.currency_code
2616: FROM pa_implementations a
2617: , gl_sets_of_books b
2618: WHERE a.set_of_books_id = b.set_of_books_id;
2619: CURSOR gl_eligible_amount IS
2620: SELECT nvl(sum( nvl(eligible_amount,0)*DECODE(subtract_flag,'Y',-1,1) ),0)
2621: FROM pa_alloc_run_GL_det

Line 4471: gl_sets_of_books a,

4467: Cursor C_fy_qtr is
4468: select decode(p_run_period_type,'PA', b.pa_period_type, a.accounted_period_type),
4469: a.period_set_name,glp.period_year,glp.quarter_num,glp.period_num,end_date
4470: from gl_periods glp,
4471: gl_sets_of_books a,
4472: pa_implementations b
4473: where a.set_of_books_id = b.set_of_books_id
4474: and glp.period_set_name = a.period_set_name
4475: and glp.period_type = decode(p_run_period_type,'PA', b.pa_period_type,