DBA Data[Home] [Help]

APPS.SPLIT_MASS_ADDITIONS_PKG dependencies on DUAL

Line 177: CURSOR C2 is Select Fa_MAss_Additions_S.nextval From sys.dual;

173: and MERGED_CODE = 'MC'
174: For UPDATE ;
175:
176:
177: CURSOR C2 is Select Fa_MAss_Additions_S.nextval From sys.dual;
178:
179: FA_NO_MERGED_CHILDREN Exception;
180:
181: Begin

Line 287: -- Calculate the Asset cost which will be posted for each individual

283: Total_Asset_YTD_Deprn := X_Parent_YTD_Deprn;
284: Total_Asset_Beginning_NBV := X_Parent_Beginning_NBV;
285: end if;
286:
287: -- Calculate the Asset cost which will be posted for each individual
288: -- asset line.
289:
290:
291: Total_Split_Unit_Cost_Fa := Round((Total_Asset_Cost_fa / X_Total_fa_Units), precision);

Line 891: select fa_massadd_distributions_s.nextval into h_dist_id from dual;

887: fetch split_dists into h_parent_dist_units, h_ccid, h_location, h_employee;
888:
889: if (split_dists%NOTFOUND) then return; end if;
890:
891: select fa_massadd_distributions_s.nextval into h_dist_id from dual;
892:
893: if (h_iter = h_num_dists) then
894: h_child_dist_units := h_child_total_units - h_child_units_so_far;
895: else