APPS.PA_BILLING_AMOUNT dependencies on PA_PERIODS

Line 70: from pa_periods pp

66: WHERE ta.project_id = X2_project_id
67: AND EXISTS
68: (
69: select 1
70: from pa_periods pp
71: where nvl(X2_accrue_through_date,sysdate) >= trunc(pp.start_date) --Removed to_date
72: and pp.period_name = ta.pa_period
73: )
74: AND EXISTS (select 1 from pa_tasks t

Line 91: from pa_periods pp

87: AND cdl.project_id = X2_project_id
88: AND EXISTS
89: (
90: select 1
91: from pa_periods pp
92: where nvl(X2_accrue_through_date,sysdate) >= trunc(pp.start_date) --Removed to_date
93: and cdl.pa_date between pp.start_date and pp.end_date
94: )
95: AND EXISTS (select 1 from pa_tasks t

Line 128: from pa_periods pp

124:
125: AND EXISTS
126: (
127: select 1
128: from pa_periods pp
129: where nvl(X2_accrue_through_date,sysdate) >= trunc(pp.start_date) --Removed to_date
130: and pp.period_name = ta.pa_period
131: )
132: UNION ALL

Line 152: from pa_periods pp

148: AND cdl.project_id = X2_project_id
149: AND EXISTS
150: (
151: select 1
152: from pa_periods pp
153: where nvl(X2_accrue_through_date,sysdate) >= trunc(pp.start_date) --Removed to_date
154: AND cdl.pa_date between pp.start_date and pp.end_date
155: )
156: );