DBA Data[Home] [Help]

APPS.PA_IND_RATE_SCHEDULES_PKG dependencies on PA_PROJECT_TYPES_ALL

Line 19: -- check against PA_PROJECT_TYPES_ALL

15: begin
16: x_return_status := 0;
17: x_stage := 0;
18:
19: -- check against PA_PROJECT_TYPES_ALL
20: begin
21: select 1
22: into x_dummy
23: from sys.dual

Line 26: from pa_project_types_all pt

22: into x_dummy
23: from sys.dual
24: where not exists
25: (select 1
26: from pa_project_types_all pt
27: where pt.cost_ind_rate_sch_id = x_ind_rate_sch_id
28: or pt.rev_ind_rate_sch_id = x_ind_rate_sch_id
29: or pt.inv_ind_rate_sch_id = x_ind_rate_sch_id
30: or pt.cint_rate_sch_id = x_ind_rate_sch_id);/* added for bug#3041364 */