DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_RUN_GL_DET

Line 2553: INSERT INTO pa_alloc_run_gl_det(

2549: , p_amount IN NUMBER
2550: , p_eligible_amount IN NUMBER ) IS
2551: BEGIN
2552: pa_debug.set_err_stack('insert_alloc_run_GL_det');
2553: INSERT INTO pa_alloc_run_gl_det(
2554: RUN_ID
2555: , RULE_ID
2556: , LINE_NUM
2557: , SOURCE_CCID

Line 2611: FROM pa_alloc_run_GL_det

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
2612: WHERE run_id = p_run_id;
2613: CURSOR get_gl_amount( p_sob_id IN NUMBER
2614: , p_source_ccid IN NUMBER
2615: , p_currency_code IN VARCHAR2