DBA Data[Home] [Help]

APPS.PA_COST_PLUS dependencies on PA_IND_RATE_SCHEDULES

Line 3079: pa_ind_rate_schedules irs

3075: t.cost_ind_sch_fixed_date
3076: INTO sch_id,
3077: sch_fixed_date
3078: FROM pa_tasks t,
3079: pa_ind_rate_schedules irs
3080: WHERE t.task_id = t_id
3081: AND t.task_id = irs.task_id
3082: AND irs.cost_ovr_sch_flag = 'Y';
3083:

Line 3091: pa_ind_rate_schedules irs

3087: t.rev_ind_sch_fixed_date
3088: INTO sch_id,
3089: sch_fixed_date
3090: FROM pa_tasks t,
3091: pa_ind_rate_schedules irs
3092: WHERE t.task_id = t_id
3093: AND t.task_id = irs.task_id
3094: AND irs.rev_ovr_sch_flag = 'Y';
3095:

Line 3103: pa_ind_rate_schedules irs

3099: t.inv_ind_sch_fixed_date
3100: INTO sch_id,
3101: sch_fixed_date
3102: FROM pa_tasks t,
3103: pa_ind_rate_schedules irs
3104: WHERE t.task_id = t_id
3105: AND t.task_id = irs.task_id
3106: AND irs.inv_ovr_sch_flag = 'Y';
3107:

Line 3225: pa_ind_rate_schedules irs

3221: INTO sch_id,
3222: sch_fixed_date
3223: FROM pa_tasks t,
3224: pa_projects_all p,
3225: pa_ind_rate_schedules irs
3226: WHERE t.task_id = t_id
3227: AND t.project_id = p.project_id
3228: AND t.project_id = irs.project_id
3229: AND irs.cost_ovr_sch_flag = 'Y'

Line 3240: pa_ind_rate_schedules irs

3236: INTO sch_id,
3237: sch_fixed_date
3238: FROM pa_tasks t,
3239: pa_projects_all p,
3240: pa_ind_rate_schedules irs
3241: WHERE t.task_id = t_id
3242: AND t.project_id = p.project_id
3243: AND t.project_id = irs.project_id
3244: AND irs.rev_ovr_sch_flag = 'Y'

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.inv_ovr_sch_flag = 'Y'

Line 3685: FROM pa_ind_rate_schedules

3681: Else
3682:
3683: SELECT ind_rate_schedule_type
3684: INTO x_ind_rate_schedule_type
3685: FROM pa_ind_rate_schedules
3686: WHERE ind_rate_sch_id = sch_id;
3687:
3688: g_ind_rate_schedule_type := x_ind_rate_schedule_type;
3689: g_sch_id := sch_id;

Line 7123: from pa_ind_rate_schedules s,

7119: x_ind_rate_sch_revision,
7120: x_ind_rate_sch_revision_type,
7121: x_start_date_active,
7122: x_end_date_active
7123: from pa_ind_rate_schedules s,
7124: pa_ind_rate_sch_revisions sr,
7125: pa_lookups pl
7126: where s.ind_rate_sch_id = sr.ind_rate_sch_id
7127: and sr.ind_rate_sch_revision_type = pl.lookup_code