DBA Data[Home] [Help]

APPS.PA_BURDEN_COSTING dependencies on PA_PROJECT_UTILS

Line 266: and pa_project_utils.Check_prj_stus_action_allowed(p.project_status_code, 'GENERATE_BURDEN') = 'Y'

262: pt.burden_account_flag in ('Y','y'))
263: and pt.org_id = p.org_id /*5368274*/
264: /* Bug#3033030 Added the following to check if the project status allows creation of
265: burden trasanction */
266: and pa_project_utils.Check_prj_stus_action_allowed(p.project_status_code, 'GENERATE_BURDEN') = 'Y'
267: and (exists (select --1 /*Added for bug#14367928 */
268: /*+ no_unnest index(CDL PA_COST_DISTRIBUTION_LINES_N10 ) */ 1
269: /*Added for bug#14531616*/
270: /* Removed ei ,pa_tasks table and changed cdl_all table to cdl view for bug# 1668634 */

Line 317: and pa_project_utils.Check_prj_stus_action_allowed(p.project_status_code, 'GENERATE_BURDEN') = 'Y'

313: and ( pt.burden_amt_display_method in ('D','d') or
314: pt.burden_amt_display_method in ('S','s') and
315: pt.burden_account_flag in ('Y','y'))
316: and pt.org_id = p.org_id
317: and pa_project_utils.Check_prj_stus_action_allowed(p.project_status_code, 'GENERATE_BURDEN') = 'Y'
318: and exists (
319: select /*+ NO_UNNEST INDEX (cdl, PA_COST_DISTRIBUTION_LINES_N10) */ 1
320: from pa_cost_distribution_lines cdl
321: where cdl.line_type||'' = 'R'