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.

APPS.PA_PPR_ROLLUP_PVT dependencies on DUAL

Line 2927: FROM DUAL

2923: -------
2924: -------
2925: ,0,0,0,0,0,0,0,0,0,0,0
2926: ,0,0,0,0
2927: FROM DUAL
2928: )
2929: WHERE PROJECT_ID = p_project_id
2930: AND ( ( PROJECT_ELEMENT_ID = p_3_level_object_id AND
2931: RBS_ELEMENT_ID = p_fact_task_arr(i) and RBS_VERSION_ID = p_rbs_cbs_version_id and p_fact_slice = 'WBS_TO_CBS_TO_RBS' )

Line 3013: FROM DUAL

3009: -------
3010: -------
3011: ,0,0,0,0,0,0,0,0,0,0,0
3012: ,0,0,0,0
3013: FROM DUAL
3014: )
3015: WHERE PROJECT_ID = p_project_id
3016: AND ( ( PROJECT_ELEMENT_ID = p_3_level_object_id AND
3017: RBS_ELEMENT_ID = p_fact_task_arr(i) and RBS_VERSION_ID = p_rbs_cbs_version_id and p_fact_slice = 'WBS_TO_CBS_TO_RBS' )

Line 3095: FROM DUAL

3091: -------
3092: -------
3093: ,0,0,0,0,0,0,0,0,0,0,0
3094: ,0,0,0,0
3095: FROM DUAL
3096: )
3097: WHERE PROJECT_ID = p_project_id
3098: AND RBS_ELEMENT_ID = p_object_id
3099: AND PROJECT_ELEMENT_ID = p_fact_task_arr(i)

Line 3166: FROM DUAL

3162: -------
3163: -------
3164: ,0,0,0,0,0,0,0,0,0,0,0
3165: ,0,0,0,0
3166: FROM DUAL
3167: )
3168: WHERE PROJECT_ID = p_project_id
3169: AND RBS_ELEMENT_ID = p_object_id
3170: AND PROJECT_ELEMENT_ID = p_fact_task_arr(i)

Line 3237: FROM DUAL

3233: -------
3234: -------
3235: ,0,0,0,0,0,0,0,0,0,0,0
3236: ,0,0,0,0
3237: FROM DUAL
3238: )
3239: WHERE PROJECT_ID = p_project_id
3240: AND ( ( cbs_element_id = p_3_level_object_id AND RBS_ELEMENT_ID = p_fact_task_arr(i) and p_fact_slice = 'CBS_TO_WBS_TO_RBS' )
3241: OR ( RBS_ELEMENT_ID = p_fact_task_arr(i) and p_fact_slice = 'WBS_TO_RBS' )

Line 3323: FROM DUAL

3319: -------
3320: -------
3321: ,0,0,0,0,0,0,0,0,0,0,0
3322: ,0,0,0,0
3323: FROM DUAL
3324: )
3325: WHERE PROJECT_ID = p_project_id
3326: AND ( ( cbs_element_id = p_3_level_object_id and RBS_ELEMENT_ID = p_fact_task_arr(i) and p_fact_slice = 'CBS_TO_WBS_TO_RBS' )
3327: OR ( RBS_ELEMENT_ID = p_fact_task_arr(i) and p_fact_slice = 'WBS_TO_RBS' )

Line 3409: FROM DUAL

3405: -------
3406: -------
3407: ,0,0,0,0,0,0,0,0,0,0,0
3408: ,0,0,0,0
3409: FROM DUAL
3410: )
3411: WHERE PROJECT_ID = p_project_id
3412: AND PROJECT_ELEMENT_ID = p_fact_task_arr(i)
3413: -- AND RBS_AGGR_LEVEL = 'T'

Line 3476: FROM DUAL

3472: -------
3473: -------
3474: ,0,0,0,0,0,0,0,0,0,0,0
3475: ,0,0,0,0
3476: FROM DUAL
3477: )
3478: WHERE PROJECT_ID = p_project_id
3479: AND PROJECT_ELEMENT_ID = p_fact_task_arr(i)
3480: -- AND RBS_AGGR_LEVEL = 'T'

Line 3543: FROM DUAL

3539: -------
3540: -------
3541: ,0,0,0,0,0,0,0,0,0,0,0
3542: ,0,0,0,0
3543: FROM DUAL
3544: )
3545: WHERE PROJECT_ID = p_project_id
3546: AND RBS_CBS_ELEMENT_ID = p_fact_task_arr(i)
3547: AND RBS_CBS_VERSION_ID = p_rbs_cbs_version_id

Line 3612: FROM DUAL

3608: -------
3609: -------
3610: ,0,0,0,0,0,0,0,0,0,0,0
3611: ,0,0,0,0
3612: FROM DUAL
3613: )
3614: WHERE PROJECT_ID = p_project_id
3615: AND RBS_CBS_ELEMENT_ID = p_fact_task_arr(i)
3616: AND RBS_CBS_VERSION_ID = p_rbs_cbs_version_id

Line 3731: from dual

3727: ,0,0,0,0,0,0,0,0,0,0,0
3728: ,0,0,0,0
3729: ,DECODE( p_fact_slice,'WBS_TO_CBS_TO_RBS',p_fact_task_arr(i),'CBS_TO_RBS',p_fact_task_arr(i),-1),decode(p_fact_slice,'WBS_TO_CBS_TO_RBS',p_rbs_cbs_version_id,'CBS_TO_RBS',p_rbs_cbs_version_id,-1)
3730: ,p_object_id, decode(p_fact_slice,'CBS_TO_WBS',p_rbs_cbs_version_id,'CBS_TO_RBS',p_rbs_cbs_version_id_2,'WBS_TO_CBS_TO_RBS',p_rbs_cbs_version_id_2,-1)
3731: from dual
3732: where l_ins_task_flag_arr(i) = 'Y';
3733:
3734:
3735: elsIf ( p_fact_slice = 'RBS_TO_WBS' ) then

Line 3802: from dual

3798: ,0,0,0,0,0,0,0,0,0,0,0
3799: ,0,0,0,0
3800: ,p_object_id, p_rbs_cbs_version_id
3801: ,-1,-1
3802: from dual
3803: where l_ins_task_flag_arr(i) = 'Y';
3804:
3805:
3806:

Line 3873: from dual

3869: ,0,0,0,0,0,0,0,0,0,0,0
3870: ,0,0,0,0
3871: ,DECODE( p_fact_slice,'CBS_TO_WBS_TO_RBS',p_fact_task_arr(i),'WBS_TO_RBS',p_fact_task_arr(i),-1), DECODE( p_fact_slice,'CBS_TO_WBS_TO_RBS',p_rbs_cbs_version_id,'WBS_TO_RBS',p_rbs_cbs_version_id,-1)
3872: ,DECODE( p_fact_slice,'CBS_TO_WBS_TO_RBS',p_3_level_object_id , 'WBS_TO_CBS',p_fact_task_arr(i),-1), DECODE( p_fact_slice,'CBS_TO_WBS_TO_RBS',p_3_level_version_id , 'WBS_TO_CBS',p_rbs_cbs_version_id,-1)
3873: from dual
3874: where l_ins_task_flag_arr(i) = 'Y';
3875:
3876:
3877: elsif ( p_fact_slice = 'WBS' ) then

Line 3939: from dual

3935: -------
3936: -------
3937: ,0,0,0,0,0,0,0,0,0,0,0
3938: ,0,0,0,0
3939: from dual
3940: where l_ins_task_flag_arr(i) = 'Y';
3941:
3942: elsif ( p_fact_slice = 'RBS' or p_fact_slice = 'CBS' ) then
3943:

Line 4003: from dual

3999: -------
4000: -------
4001: ,0,0,0,0,0,0,0,0,0,0,0
4002: ,0,0,0,0
4003: from dual
4004: where l_ins_task_flag_arr(i) = 'Y';
4005:
4006: end if;
4007: