DBA Data[Home] [Help]

APPS.PA_COST_PLUS_STRUCTURE_PKG dependencies on PA_IND_RATE_SCH_REVISIONS

Line 64: -- check pa_ind_rate_sch_revisions table

60: begin
61:
62: status := 0;
63:
64: -- check pa_ind_rate_sch_revisions table
65:
66: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
67: (SELECT 1 FROM pa_ind_rate_sch_revisions irsr
68: WHERE irsr.cost_plus_structure = cp_structure);

Line 67: (SELECT 1 FROM pa_ind_rate_sch_revisions irsr

63:
64: -- check pa_ind_rate_sch_revisions table
65:
66: SELECT 1 INTO dummy FROM sys.dual WHERE NOT EXISTS
67: (SELECT 1 FROM pa_ind_rate_sch_revisions irsr
68: WHERE irsr.cost_plus_structure = cp_structure);
69:
70: exception
71: