DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_IND_RATE_SCHEDULES

Line 96: pa_ind_rate_schedules irs

92: SELECT t.cost_ind_rate_sch_id,
93: t.cost_ind_sch_fixed_date
94: INTO l_sch_id ,l_sch_date
95: FROM pa_tasks t,
96: pa_ind_rate_schedules irs
97: WHERE t.task_id = p_task_id
98: AND t.cost_ind_rate_sch_id = irs.ind_rate_sch_id
99: AND irs.cost_ovr_sch_flag = 'Y';
100: */

Line 107: pa_ind_rate_schedules irs

103: SELECT irs.ind_rate_sch_id,
104: t.cost_ind_sch_fixed_date
105: INTO l_sch_id,l_sch_date
106: FROM pa_tasks t,
107: pa_ind_rate_schedules irs
108: WHERE t.task_id = p_task_id
109: AND t.task_id = irs.task_id
110: AND irs.cost_ovr_sch_flag = 'Y';
111:

Line 122: pa_ind_rate_schedules irs

118: p.cost_ind_sch_fixed_date
119: INTO l_sch_id,l_sch_date
120: FROM pa_tasks t,
121: pa_projects_all p,
122: pa_ind_rate_schedules irs
123: WHERE t.task_id = p_task_id
124: AND t.project_id = p.project_id
125: AND t.project_id = irs.project_id
126: AND irs.cost_ovr_sch_flag = 'Y'

Line 137: pa_ind_rate_schedules irs

133: SELECT t.cost_ind_rate_sch_id,
134: t.cost_ind_sch_fixed_date
135: INTO l_sch_id ,l_sch_date
136: FROM pa_tasks t,
137: pa_ind_rate_schedules irs
138: WHERE t.task_id = p_task_id
139: AND t.cost_ind_rate_sch_id = irs.ind_rate_sch_id;
140: EXCEPTION
141:

Line 303: -- pa_ind_rate_schedules_all_bg irs,

299: -- pa_cost_bases cb,
300: -- pa_expenditure_types et,
301: -- pa_ind_cost_codes icc,
302: -- pa_cost_base_exp_types cbet,
303: -- pa_ind_rate_schedules_all_bg irs,
304: -- pa_ind_compiled_sets ics,
305: -- pa_compiled_multipliers cm
306: -- WHERE irsr.cost_plus_structure = cbet.cost_plus_structure
307: -- AND cb.cost_base = cbet.cost_base