APPS.ZX_PARTY_TAX_PROFILE_PKG dependencies on DUAL

Line 58: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;

54: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
55: begin
56: --Initialise x_return_status variable
57: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
58: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
59: --Perform validations before inserting data
60: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
61: BEGIN
62: -- Check created module name

Line 260: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;

256: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
257: begin
258: --Initialise x_return_status variable
259: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
260: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
261: BEGIN
262: -- Check created module name
263: select nvl(substr(created_by_module,1,3),'ZX') created_by_module
264: into L_CREATED_BY_MODULE