APPS.JTF_PERZ_DATA_PVT dependencies on DUAL

Line 59: CURSOR C2 IS SELECT JTF_PERZ_DATA_S.nextval FROM sys.dual;

55: p_PERZ_DATA_DESC VARCHAR2
56: )
57:
58: IS
59: CURSOR C2 IS SELECT JTF_PERZ_DATA_S.nextval FROM sys.dual;
60: BEGIN
61: If (px_PERZ_DATA_ID IS NULL) OR (px_PERZ_DATA_ID = FND_API.G_MISS_NUM) then
62: OPEN C2;
63: FETCH C2 INTO px_PERZ_DATA_ID;

Line 98: CURSOR C2 IS SELECT JTF_PERZ_DATA_ATTRIBUTES_S.nextval FROM sys.dual;

94: p_ATTRIBUTE_VALUE VARCHAR2,
95: p_ATTRIBUTE_CONTEXT VARCHAR2)
96:
97: IS
98: CURSOR C2 IS SELECT JTF_PERZ_DATA_ATTRIBUTES_S.nextval FROM sys.dual;
99: BEGIN
100: If (px_PERZ_DATA_ATTRIB_ID IS NULL) OR (px_PERZ_DATA_ATTRIB_ID = FND_API.G_MISS_NUM) then
101: OPEN C2;
102: FETCH C2 INTO px_PERZ_DATA_ATTRIB_ID;

Line 891: -- Instead of individual temp variables, this will be referred in the select

887:
888: -- Temporary Variables
889: -- SMATTEGU Enhancement #1181062 Begin
890: l_perz_data_temp_rec JTF_PERZ_DATA_PUB.DATA_OUT_REC_TYPE;
891: -- Instead of individual temp variables, this will be referred in the select
892: -- into statements etc.
893: -- SMATTEGU Enhancement #1181062 End
894: /*
895: l_perz_data_id_temp number;