DBA Data[Home] [Help]

APPS.PA_MCB_REVENUE_PKG dependencies on PA_TASKS

Line 101: FROM pa_tasks t

97: AND v.request_id = p_request_id
98: AND v. revenue_distributed_flag = 'D'
99: AND nvl(v.task_id, -1) IN
100: (SELECT decode(v.task_id, null, -1, t.task_id )
101: FROM pa_tasks t
102: WHERE t.project_id = p_project_id
103: AND t.ready_to_distribute_flag ||'' = 'Y'
104: )
105: AND TRUNC(v.completion_date) <= TRUNC(NVL(p_acc_thru_dt,sysdate)) /* Bug#3118592 */

Line 159: FROM pa_tasks tsk

155: AND vt.event_type = evt.event_type ||''
156: AND vt.event_type_classification ||'' IN
157: ('WRITE ON','WRITE OFF','MANUAL','REALIZED_GAINS','REALIZED_LOSSES')
158: AND EXISTS ( SELECT 'ready to distribute top task exists'
159: FROM pa_tasks tsk
160: WHERE tsk.project_id = p_project_id
161: AND tsk.task_id = NVL( evt.task_id, tsk.task_id )
162: AND tsk.ready_to_distribute_flag ||'' = 'Y'
163: )