DBA Data[Home] [Help]

APPS.PA_COST_PLUS dependencies on PA_IND_RATE_SCHEDULES

Line 3109: pa_ind_rate_schedules irs

3105: t.cost_ind_sch_fixed_date
3106: INTO sch_id,
3107: sch_fixed_date
3108: FROM pa_tasks t,
3109: pa_ind_rate_schedules irs
3110: WHERE t.task_id = t_id
3111: AND t.task_id = irs.task_id
3112: AND irs.cost_ovr_sch_flag = 'Y';
3113:

Line 3121: pa_ind_rate_schedules irs

3117: t.rev_ind_sch_fixed_date
3118: INTO sch_id,
3119: sch_fixed_date
3120: FROM pa_tasks t,
3121: pa_ind_rate_schedules irs
3122: WHERE t.task_id = t_id
3123: AND t.task_id = irs.task_id
3124: AND irs.rev_ovr_sch_flag = 'Y';
3125:

Line 3133: pa_ind_rate_schedules irs

3129: t.inv_ind_sch_fixed_date
3130: INTO sch_id,
3131: sch_fixed_date
3132: FROM pa_tasks t,
3133: pa_ind_rate_schedules irs
3134: WHERE t.task_id = t_id
3135: AND t.task_id = irs.task_id
3136: AND irs.inv_ovr_sch_flag = 'Y';
3137:

Line 3255: pa_ind_rate_schedules irs

3251: INTO sch_id,
3252: sch_fixed_date
3253: FROM pa_tasks t,
3254: pa_projects_all p,
3255: pa_ind_rate_schedules irs
3256: WHERE t.task_id = t_id
3257: AND t.project_id = p.project_id
3258: AND t.project_id = irs.project_id
3259: AND irs.cost_ovr_sch_flag = 'Y'

Line 3270: pa_ind_rate_schedules irs

3266: INTO sch_id,
3267: sch_fixed_date
3268: FROM pa_tasks t,
3269: pa_projects_all p,
3270: pa_ind_rate_schedules irs
3271: WHERE t.task_id = t_id
3272: AND t.project_id = p.project_id
3273: AND t.project_id = irs.project_id
3274: AND irs.rev_ovr_sch_flag = 'Y'

Line 3285: pa_ind_rate_schedules irs

3281: INTO sch_id,
3282: sch_fixed_date
3283: FROM pa_tasks t,
3284: pa_projects_all p,
3285: pa_ind_rate_schedules irs
3286: WHERE t.task_id = t_id
3287: AND t.project_id = p.project_id
3288: AND t.project_id = irs.project_id
3289: AND irs.inv_ovr_sch_flag = 'Y'

Line 3715: FROM pa_ind_rate_schedules

3711: Else
3712:
3713: SELECT ind_rate_schedule_type
3714: INTO x_ind_rate_schedule_type
3715: FROM pa_ind_rate_schedules
3716: WHERE ind_rate_sch_id = sch_id;
3717:
3718: g_ind_rate_schedule_type := x_ind_rate_schedule_type;
3719: g_sch_id := sch_id;

Line 7350: from pa_ind_rate_schedules s,

7346: x_ind_rate_sch_revision,
7347: x_ind_rate_sch_revision_type,
7348: x_start_date_active,
7349: x_end_date_active
7350: from pa_ind_rate_schedules s,
7351: pa_ind_rate_sch_revisions sr,
7352: pa_lookups pl
7353: where s.ind_rate_sch_id = sr.ind_rate_sch_id
7354: and sr.ind_rate_sch_revision_type = pl.lookup_code