DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_IND_RATE_SCHEDULES

Line 124: pa_ind_rate_schedules irs

120: SELECT t.cost_ind_rate_sch_id,
121: t.cost_ind_sch_fixed_date
122: INTO l_sch_id ,l_sch_date
123: FROM pa_tasks t,
124: pa_ind_rate_schedules irs
125: WHERE t.task_id = p_task_id
126: AND t.cost_ind_rate_sch_id = irs.ind_rate_sch_id
127: AND irs.cost_ovr_sch_flag = 'Y';
128: */

Line 135: pa_ind_rate_schedules irs

131: SELECT irs.ind_rate_sch_id,
132: t.cost_ind_sch_fixed_date
133: INTO l_sch_id,l_sch_date
134: FROM pa_tasks t,
135: pa_ind_rate_schedules irs
136: WHERE t.task_id = p_task_id
137: AND t.task_id = irs.task_id
138: AND irs.cost_ovr_sch_flag = 'Y';
139:

Line 150: pa_ind_rate_schedules irs

146: p.cost_ind_sch_fixed_date
147: INTO l_sch_id,l_sch_date
148: FROM pa_tasks t,
149: pa_projects_all p,
150: pa_ind_rate_schedules irs
151: WHERE t.task_id = p_task_id
152: AND t.project_id = p.project_id
153: AND t.project_id = irs.project_id
154: AND irs.cost_ovr_sch_flag = 'Y'

Line 165: pa_ind_rate_schedules irs

161: SELECT t.cost_ind_rate_sch_id,
162: t.cost_ind_sch_fixed_date
163: INTO l_sch_id ,l_sch_date
164: FROM pa_tasks t,
165: pa_ind_rate_schedules irs
166: WHERE t.task_id = p_task_id
167: AND t.cost_ind_rate_sch_id = irs.ind_rate_sch_id;
168: EXCEPTION
169:

Line 368: -- pa_ind_rate_schedules_all_bg irs,

364: -- pa_cost_bases cb,
365: -- pa_expenditure_types et,
366: -- pa_ind_cost_codes icc,
367: -- pa_cost_base_exp_types cbet,
368: -- pa_ind_rate_schedules_all_bg irs,
369: -- pa_ind_compiled_sets ics,
370: -- pa_compiled_multipliers cm
371: -- WHERE irsr.cost_plus_structure = cbet.cost_plus_structure
372: -- AND cb.cost_base = cbet.cost_base