DBA Data[Home] [Help]

APPS.PA_COST_DIST_OVERRIDES_PKG dependencies on DUAL

Line 21: CURSOR C2 IS SELECT pa_cost_dist_overrides_s.nextval FROM sys.dual;

17: X_End_Date_Active DATE
18: ) IS
19: CURSOR C IS SELECT rowid FROM PA_COST_DIST_OVERRIDES
20: WHERE cost_distribution_override_id = X_Cost_Dist_Override_Id;
21: CURSOR C2 IS SELECT pa_cost_dist_overrides_s.nextval FROM sys.dual;
22: BEGIN
23: if (X_Cost_Dist_Override_Id is NULL) then
24: OPEN C2;
25: FETCH C2 INTO X_Cost_Dist_Override_Id;