DBA Data[Home] [Help]

APPS.SPLIT_MASS_ADDITIONS_PKG dependencies on DUAL

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

162: and MERGED_CODE = 'MC'
163: For UPDATE ;
164:
165:
166: CURSOR C2 is Select Fa_MAss_Additions_S.nextval From sys.dual;
167:
168: FA_NO_MERGED_CHILDREN Exception;
169:
170: Begin

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

267: Total_Asset_YTD_Deprn := X_Parent_YTD_Deprn;
268: Total_Asset_Beginning_NBV := X_Parent_Beginning_NBV;
269: end if;
270:
271: -- Calculate the Asset cost which will be posted for each individual
272: -- asset line.
273:
274:
275: Total_Split_Unit_Cost_Fa := Round((Total_Asset_Cost_fa / X_Total_fa_Units), precision);

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

844: fetch split_dists into h_parent_dist_units, h_ccid, h_location, h_employee;
845:
846: if (split_dists%NOTFOUND) then return; end if;
847:
848: select fa_massadd_distributions_s.nextval into h_dist_id from dual;
849:
850: if (h_iter = h_num_dists) then
851: h_child_dist_units := h_child_total_units - h_child_units_so_far;
852: else