DBA Data[Home] [Help]

APPS.JTF_PREFAB_CA_COMPS_PKG dependencies on DUAL

Line 33: select JTF.CA_COMP_ID_SEQ.nextval into l_ca_comp_id from dual;

29: -- where CA_COMP_ID = X_CA_COMP_ID;
30: begin
31: -- The following select is required as we are referring the X_CA_COMP_ID in
32: -- two insert statements and calling JTF.CA_COMP_ID_SEQ.nextval twice will return two different values.
33: select JTF.CA_COMP_ID_SEQ.nextval into l_ca_comp_id from dual;
34: insert into JTF_PREFAB_CA_COMPS_B (
35: -- SECURITY_GROUP_ID,
36: APPLICATION_ID,
37: COMP_NAME,