APPS.PA_BUDGET_FUND_PKG dependencies on PA_PERIOD_PROCESS_PKG

Line 23: WHERE GLS.application_id = PA_Period_Process_Pkg.Application_ID -- 101

19: WHERE EXISTS
20: (SELECT 'X'
21: FROM PA_BUDGET_ACCT_LINES PBA,
22: GL_PERIOD_STATUSES GLS
23: WHERE GLS.application_id = PA_Period_Process_Pkg.Application_ID -- 101
24: AND GLS.set_of_books_id = c_set_of_books_id
25: AND GLS.period_name = PBA.gl_period_name
26: AND GLS.closing_status not in ('O' , 'F' )
27: AND PBA.curr_ver_available_amount <> PBA.prev_ver_available_amount

Line 305: AND GP.application_id = PA_Period_Process_Pkg.Application_ID; -- 101

301: AND PBA.budget_version_id = p_budget_version_id
302: AND GL.code_combination_id = PBA.code_combination_id
303: AND GP.set_of_books_id = l_set_of_books_id
304: AND GP.period_name = PBA.gl_period_name
305: AND GP.application_id = PA_Period_Process_Pkg.Application_ID; -- 101
306:
307: /* AND GP.closing_status in ('O','F') ; Commented out period status check. for Bug 2950493 */
308:
309: log_message('rows inserted into IGC Table .. '||sql%rowcount);