eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_PROJ_WORKPLAN_ATTR

Line 646: exists ( select 'x' from pa_proj_workplan_attr w1

642: pa_proj_structure_types ppst,
643: pa_structure_types pst
644: where s.project_id = L_PROJECT_OUT_OBJ.pa_project_id
645: and ( ( s.status_code = 'STRUCTURE_WORKING' AND
646: exists ( select 'x' from pa_proj_workplan_attr w1
647: where w1.project_id = s.project_id
648: and w1.wp_enable_version_flag = 'Y' ) )
649: OR
650: ( s.status_code = 'STRUCTURE_PUBLISHED' AND

Line 651: exists ( select 'x' from pa_proj_workplan_attr w2

647: where w1.project_id = s.project_id
648: and w1.wp_enable_version_flag = 'Y' ) )
649: OR
650: ( s.status_code = 'STRUCTURE_PUBLISHED' AND
651: exists ( select 'x' from pa_proj_workplan_attr w2
652: where w2.project_id = s.project_id
653: and w2.wp_enable_version_flag = 'N' ))
654: )
655: and s.current_working_flag = 'Y'

Line 669: exists ( select 'x' from pa_proj_workplan_attr w1

665: pa_budget_versions bud,
666: pa_proj_fp_options opt
667: where s.project_id = L_PROJECT_OUT_OBJ.pa_project_id
668: and ( ( s.status_code = 'STRUCTURE_WORKING' AND
669: exists ( select 'x' from pa_proj_workplan_attr w1
670: where w1.project_id = s.project_id
671: and w1.wp_enable_version_flag = 'Y' ) )
672: OR
673: ( s.status_code = 'STRUCTURE_PUBLISHED' AND

Line 674: exists ( select 'x' from pa_proj_workplan_attr w2

670: where w1.project_id = s.project_id
671: and w1.wp_enable_version_flag = 'Y' ) )
672: OR
673: ( s.status_code = 'STRUCTURE_PUBLISHED' AND
674: exists ( select 'x' from pa_proj_workplan_attr w2
675: where w2.project_id = s.project_id
676: and w2.wp_enable_version_flag = 'N' ))
677: )
678: and s.current_working_flag = 'Y'

Line 720: exists ( select 'x' from pa_proj_workplan_attr w1

716: and s.project_id = a.project_id
717: and a.parent_structure_version_id = s.element_version_id
718: and a.object_type = 'PA_TASKS'
719: and ( ( s.status_code = 'STRUCTURE_WORKING' AND
720: exists ( select 'x' from pa_proj_workplan_attr w1
721: where w1.project_id = s.project_id
722: and w1.wp_enable_version_flag = 'Y' ) )
723: OR
724: ( s.status_code = 'STRUCTURE_PUBLISHED' AND

Line 725: exists ( select 'x' from pa_proj_workplan_attr w2

721: where w1.project_id = s.project_id
722: and w1.wp_enable_version_flag = 'Y' ) )
723: OR
724: ( s.status_code = 'STRUCTURE_PUBLISHED' AND
725: exists ( select 'x' from pa_proj_workplan_attr w2
726: where w2.project_id = s.project_id
727: and w2.wp_enable_version_flag = 'N' )
728: )
729: )

Line 1876: exists ( select 'x' from pa_proj_workplan_attr w1

1872: pa_structure_types pst
1873: where ppevs.proj_element_id = ppst.proj_element_id
1874: and ppevs.project_id = l_PROJECT_IN_OBJ.PA_PROJECT_ID
1875: and ( ( ppevs.status_code = 'STRUCTURE_WORKING' AND
1876: exists ( select 'x' from pa_proj_workplan_attr w1
1877: where w1.project_id = ppevs.project_id
1878: and w1.wp_enable_version_flag = 'Y' ) )
1879: OR
1880: ( ppevs.status_code = 'STRUCTURE_PUBLISHED' AND

Line 1881: exists ( select 'x' from pa_proj_workplan_attr w2

1877: where w1.project_id = ppevs.project_id
1878: and w1.wp_enable_version_flag = 'Y' ) )
1879: OR
1880: ( ppevs.status_code = 'STRUCTURE_PUBLISHED' AND
1881: exists ( select 'x' from pa_proj_workplan_attr w2
1882: where w2.project_id = ppevs.project_id
1883: and w2.wp_enable_version_flag = 'N' ))
1884: )
1885: and ppevs.current_working_flag = 'Y'