DBA Data[Home] [Help]

APPS.PA_ALLOC_RUN dependencies on PA_ALLOC_GL_LINES

Line 763: FROM pa_alloc_GL_lines

759: FROM pa_alloc_source_lines
760: WHERE rule_id = p_rule_id ;
761: CURSOR C_gl_src_exists IS
762: SELECT 1
763: FROM pa_alloc_GL_lines
764: WHERE rule_id = p_rule_id ;
765: CURSOR C_target_lines IS
766: SELECT project_id, task_id, exclude_flag, billable_only_flag
767: FROM pa_alloc_target_lines

Line 2600: FROM pa_alloc_gl_lines

2596: SELECT source_ccid
2597: , nvl(source_percent,100) source_percent
2598: , subtract_flag
2599: , line_num
2600: FROM pa_alloc_gl_lines
2601: WHERE rule_id = p_rule_id;
2602: CURSOR gl_account_dets IS
2603: SELECT a.set_of_books_id
2604: , b.accounted_period_type